package com.leshua.channel.mpos.model.lepos;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class MerchantTmpExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public MerchantTmpExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("F_id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("F_id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("F_id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("F_id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("F_id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("F_id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("F_id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("F_id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("F_id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("F_id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("F_id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUserNameIsNull() {
            addCriterion("F_user_name is null");
            return (Criteria) this;
        }

        public Criteria andUserNameIsNotNull() {
            addCriterion("F_user_name is not null");
            return (Criteria) this;
        }

        public Criteria andUserNameEqualTo(String value) {
            addCriterion("F_user_name =", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotEqualTo(String value) {
            addCriterion("F_user_name <>", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThan(String value) {
            addCriterion("F_user_name >", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("F_user_name >=", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLessThan(String value) {
            addCriterion("F_user_name <", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLessThanOrEqualTo(String value) {
            addCriterion("F_user_name <=", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLike(String value) {
            addCriterion("F_user_name like", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotLike(String value) {
            addCriterion("F_user_name not like", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameIn(List<String> values) {
            addCriterion("F_user_name in", values, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotIn(List<String> values) {
            addCriterion("F_user_name not in", values, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameBetween(String value1, String value2) {
            addCriterion("F_user_name between", value1, value2, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotBetween(String value1, String value2) {
            addCriterion("F_user_name not between", value1, value2, "userName");
            return (Criteria) this;
        }

        public Criteria andUserPasswordIsNull() {
            addCriterion("F_user_password is null");
            return (Criteria) this;
        }

        public Criteria andUserPasswordIsNotNull() {
            addCriterion("F_user_password is not null");
            return (Criteria) this;
        }

        public Criteria andUserPasswordEqualTo(String value) {
            addCriterion("F_user_password =", value, "userPassword");
            return (Criteria) this;
        }

        public Criteria andUserPasswordNotEqualTo(String value) {
            addCriterion("F_user_password <>", value, "userPassword");
            return (Criteria) this;
        }

        public Criteria andUserPasswordGreaterThan(String value) {
            addCriterion("F_user_password >", value, "userPassword");
            return (Criteria) this;
        }

        public Criteria andUserPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("F_user_password >=", value, "userPassword");
            return (Criteria) this;
        }

        public Criteria andUserPasswordLessThan(String value) {
            addCriterion("F_user_password <", value, "userPassword");
            return (Criteria) this;
        }

        public Criteria andUserPasswordLessThanOrEqualTo(String value) {
            addCriterion("F_user_password <=", value, "userPassword");
            return (Criteria) this;
        }

        public Criteria andUserPasswordLike(String value) {
            addCriterion("F_user_password like", value, "userPassword");
            return (Criteria) this;
        }

        public Criteria andUserPasswordNotLike(String value) {
            addCriterion("F_user_password not like", value, "userPassword");
            return (Criteria) this;
        }

        public Criteria andUserPasswordIn(List<String> values) {
            addCriterion("F_user_password in", values, "userPassword");
            return (Criteria) this;
        }

        public Criteria andUserPasswordNotIn(List<String> values) {
            addCriterion("F_user_password not in", values, "userPassword");
            return (Criteria) this;
        }

        public Criteria andUserPasswordBetween(String value1, String value2) {
            addCriterion("F_user_password between", value1, value2, "userPassword");
            return (Criteria) this;
        }

        public Criteria andUserPasswordNotBetween(String value1, String value2) {
            addCriterion("F_user_password not between", value1, value2, "userPassword");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("F_mobile is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("F_mobile is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("F_mobile =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("F_mobile <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("F_mobile >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("F_mobile >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("F_mobile <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("F_mobile <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("F_mobile like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("F_mobile not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("F_mobile in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("F_mobile not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("F_mobile between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("F_mobile not between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptIsNull() {
            addCriterion("F_mobile_encrypt is null");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptIsNotNull() {
            addCriterion("F_mobile_encrypt is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptEqualTo(String value) {
            addCriterion("F_mobile_encrypt =", value, "mobileEncrypt");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptNotEqualTo(String value) {
            addCriterion("F_mobile_encrypt <>", value, "mobileEncrypt");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptGreaterThan(String value) {
            addCriterion("F_mobile_encrypt >", value, "mobileEncrypt");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptGreaterThanOrEqualTo(String value) {
            addCriterion("F_mobile_encrypt >=", value, "mobileEncrypt");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptLessThan(String value) {
            addCriterion("F_mobile_encrypt <", value, "mobileEncrypt");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptLessThanOrEqualTo(String value) {
            addCriterion("F_mobile_encrypt <=", value, "mobileEncrypt");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptLike(String value) {
            addCriterion("F_mobile_encrypt like", value, "mobileEncrypt");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptNotLike(String value) {
            addCriterion("F_mobile_encrypt not like", value, "mobileEncrypt");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptIn(List<String> values) {
            addCriterion("F_mobile_encrypt in", values, "mobileEncrypt");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptNotIn(List<String> values) {
            addCriterion("F_mobile_encrypt not in", values, "mobileEncrypt");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptBetween(String value1, String value2) {
            addCriterion("F_mobile_encrypt between", value1, value2, "mobileEncrypt");
            return (Criteria) this;
        }

        public Criteria andMobileEncryptNotBetween(String value1, String value2) {
            addCriterion("F_mobile_encrypt not between", value1, value2, "mobileEncrypt");
            return (Criteria) this;
        }

        public Criteria andMerchantTypeIsNull() {
            addCriterion("F_merchant_type is null");
            return (Criteria) this;
        }

        public Criteria andMerchantTypeIsNotNull() {
            addCriterion("F_merchant_type is not null");
            return (Criteria) this;
        }

        public Criteria andMerchantTypeEqualTo(Integer value) {
            addCriterion("F_merchant_type =", value, "merchantType");
            return (Criteria) this;
        }

        public Criteria andMerchantTypeNotEqualTo(Integer value) {
            addCriterion("F_merchant_type <>", value, "merchantType");
            return (Criteria) this;
        }

        public Criteria andMerchantTypeGreaterThan(Integer value) {
            addCriterion("F_merchant_type >", value, "merchantType");
            return (Criteria) this;
        }

        public Criteria andMerchantTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_merchant_type >=", value, "merchantType");
            return (Criteria) this;
        }

        public Criteria andMerchantTypeLessThan(Integer value) {
            addCriterion("F_merchant_type <", value, "merchantType");
            return (Criteria) this;
        }

        public Criteria andMerchantTypeLessThanOrEqualTo(Integer value) {
            addCriterion("F_merchant_type <=", value, "merchantType");
            return (Criteria) this;
        }

        public Criteria andMerchantTypeIn(List<Integer> values) {
            addCriterion("F_merchant_type in", values, "merchantType");
            return (Criteria) this;
        }

        public Criteria andMerchantTypeNotIn(List<Integer> values) {
            addCriterion("F_merchant_type not in", values, "merchantType");
            return (Criteria) this;
        }

        public Criteria andMerchantTypeBetween(Integer value1, Integer value2) {
            addCriterion("F_merchant_type between", value1, value2, "merchantType");
            return (Criteria) this;
        }

        public Criteria andMerchantTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("F_merchant_type not between", value1, value2, "merchantType");
            return (Criteria) this;
        }

        public Criteria andApplicantIsNull() {
            addCriterion("F_applicant is null");
            return (Criteria) this;
        }

        public Criteria andApplicantIsNotNull() {
            addCriterion("F_applicant is not null");
            return (Criteria) this;
        }

        public Criteria andApplicantEqualTo(String value) {
            addCriterion("F_applicant =", value, "applicant");
            return (Criteria) this;
        }

        public Criteria andApplicantNotEqualTo(String value) {
            addCriterion("F_applicant <>", value, "applicant");
            return (Criteria) this;
        }

        public Criteria andApplicantGreaterThan(String value) {
            addCriterion("F_applicant >", value, "applicant");
            return (Criteria) this;
        }

        public Criteria andApplicantGreaterThanOrEqualTo(String value) {
            addCriterion("F_applicant >=", value, "applicant");
            return (Criteria) this;
        }

        public Criteria andApplicantLessThan(String value) {
            addCriterion("F_applicant <", value, "applicant");
            return (Criteria) this;
        }

        public Criteria andApplicantLessThanOrEqualTo(String value) {
            addCriterion("F_applicant <=", value, "applicant");
            return (Criteria) this;
        }

        public Criteria andApplicantLike(String value) {
            addCriterion("F_applicant like", value, "applicant");
            return (Criteria) this;
        }

        public Criteria andApplicantNotLike(String value) {
            addCriterion("F_applicant not like", value, "applicant");
            return (Criteria) this;
        }

        public Criteria andApplicantIn(List<String> values) {
            addCriterion("F_applicant in", values, "applicant");
            return (Criteria) this;
        }

        public Criteria andApplicantNotIn(List<String> values) {
            addCriterion("F_applicant not in", values, "applicant");
            return (Criteria) this;
        }

        public Criteria andApplicantBetween(String value1, String value2) {
            addCriterion("F_applicant between", value1, value2, "applicant");
            return (Criteria) this;
        }

        public Criteria andApplicantNotBetween(String value1, String value2) {
            addCriterion("F_applicant not between", value1, value2, "applicant");
            return (Criteria) this;
        }

        public Criteria andIdcardIsNull() {
            addCriterion("F_idcard is null");
            return (Criteria) this;
        }

        public Criteria andIdcardIsNotNull() {
            addCriterion("F_idcard is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardEqualTo(String value) {
            addCriterion("F_idcard =", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotEqualTo(String value) {
            addCriterion("F_idcard <>", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardGreaterThan(String value) {
            addCriterion("F_idcard >", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardGreaterThanOrEqualTo(String value) {
            addCriterion("F_idcard >=", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardLessThan(String value) {
            addCriterion("F_idcard <", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardLessThanOrEqualTo(String value) {
            addCriterion("F_idcard <=", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardLike(String value) {
            addCriterion("F_idcard like", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotLike(String value) {
            addCriterion("F_idcard not like", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardIn(List<String> values) {
            addCriterion("F_idcard in", values, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotIn(List<String> values) {
            addCriterion("F_idcard not in", values, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardBetween(String value1, String value2) {
            addCriterion("F_idcard between", value1, value2, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotBetween(String value1, String value2) {
            addCriterion("F_idcard not between", value1, value2, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptIsNull() {
            addCriterion("F_idcard_encrypt is null");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptIsNotNull() {
            addCriterion("F_idcard_encrypt is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptEqualTo(String value) {
            addCriterion("F_idcard_encrypt =", value, "idcardEncrypt");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptNotEqualTo(String value) {
            addCriterion("F_idcard_encrypt <>", value, "idcardEncrypt");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptGreaterThan(String value) {
            addCriterion("F_idcard_encrypt >", value, "idcardEncrypt");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptGreaterThanOrEqualTo(String value) {
            addCriterion("F_idcard_encrypt >=", value, "idcardEncrypt");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptLessThan(String value) {
            addCriterion("F_idcard_encrypt <", value, "idcardEncrypt");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptLessThanOrEqualTo(String value) {
            addCriterion("F_idcard_encrypt <=", value, "idcardEncrypt");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptLike(String value) {
            addCriterion("F_idcard_encrypt like", value, "idcardEncrypt");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptNotLike(String value) {
            addCriterion("F_idcard_encrypt not like", value, "idcardEncrypt");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptIn(List<String> values) {
            addCriterion("F_idcard_encrypt in", values, "idcardEncrypt");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptNotIn(List<String> values) {
            addCriterion("F_idcard_encrypt not in", values, "idcardEncrypt");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptBetween(String value1, String value2) {
            addCriterion("F_idcard_encrypt between", value1, value2, "idcardEncrypt");
            return (Criteria) this;
        }

        public Criteria andIdcardEncryptNotBetween(String value1, String value2) {
            addCriterion("F_idcard_encrypt not between", value1, value2, "idcardEncrypt");
            return (Criteria) this;
        }

        public Criteria andMerchantNameIsNull() {
            addCriterion("F_merchant_name is null");
            return (Criteria) this;
        }

        public Criteria andMerchantNameIsNotNull() {
            addCriterion("F_merchant_name is not null");
            return (Criteria) this;
        }

        public Criteria andMerchantNameEqualTo(String value) {
            addCriterion("F_merchant_name =", value, "merchantName");
            return (Criteria) this;
        }

        public Criteria andMerchantNameNotEqualTo(String value) {
            addCriterion("F_merchant_name <>", value, "merchantName");
            return (Criteria) this;
        }

        public Criteria andMerchantNameGreaterThan(String value) {
            addCriterion("F_merchant_name >", value, "merchantName");
            return (Criteria) this;
        }

        public Criteria andMerchantNameGreaterThanOrEqualTo(String value) {
            addCriterion("F_merchant_name >=", value, "merchantName");
            return (Criteria) this;
        }

        public Criteria andMerchantNameLessThan(String value) {
            addCriterion("F_merchant_name <", value, "merchantName");
            return (Criteria) this;
        }

        public Criteria andMerchantNameLessThanOrEqualTo(String value) {
            addCriterion("F_merchant_name <=", value, "merchantName");
            return (Criteria) this;
        }

        public Criteria andMerchantNameLike(String value) {
            addCriterion("F_merchant_name like", value, "merchantName");
            return (Criteria) this;
        }

        public Criteria andMerchantNameNotLike(String value) {
            addCriterion("F_merchant_name not like", value, "merchantName");
            return (Criteria) this;
        }

        public Criteria andMerchantNameIn(List<String> values) {
            addCriterion("F_merchant_name in", values, "merchantName");
            return (Criteria) this;
        }

        public Criteria andMerchantNameNotIn(List<String> values) {
            addCriterion("F_merchant_name not in", values, "merchantName");
            return (Criteria) this;
        }

        public Criteria andMerchantNameBetween(String value1, String value2) {
            addCriterion("F_merchant_name between", value1, value2, "merchantName");
            return (Criteria) this;
        }

        public Criteria andMerchantNameNotBetween(String value1, String value2) {
            addCriterion("F_merchant_name not between", value1, value2, "merchantName");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("F_province is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("F_province is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("F_province =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("F_province <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("F_province >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("F_province >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("F_province <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("F_province <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("F_province like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("F_province not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("F_province in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("F_province not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("F_province between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("F_province not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("F_city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("F_city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("F_city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("F_city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("F_city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("F_city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("F_city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("F_city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("F_city like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("F_city not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("F_city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("F_city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("F_city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("F_city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andAreaIsNull() {
            addCriterion("F_area is null");
            return (Criteria) this;
        }

        public Criteria andAreaIsNotNull() {
            addCriterion("F_area is not null");
            return (Criteria) this;
        }

        public Criteria andAreaEqualTo(String value) {
            addCriterion("F_area =", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotEqualTo(String value) {
            addCriterion("F_area <>", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaGreaterThan(String value) {
            addCriterion("F_area >", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaGreaterThanOrEqualTo(String value) {
            addCriterion("F_area >=", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLessThan(String value) {
            addCriterion("F_area <", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLessThanOrEqualTo(String value) {
            addCriterion("F_area <=", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLike(String value) {
            addCriterion("F_area like", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotLike(String value) {
            addCriterion("F_area not like", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaIn(List<String> values) {
            addCriterion("F_area in", values, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotIn(List<String> values) {
            addCriterion("F_area not in", values, "area");
            return (Criteria) this;
        }

        public Criteria andAreaBetween(String value1, String value2) {
            addCriterion("F_area between", value1, value2, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotBetween(String value1, String value2) {
            addCriterion("F_area not between", value1, value2, "area");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("F_address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("F_address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("F_address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("F_address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("F_address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("F_address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("F_address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("F_address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("F_address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("F_address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("F_address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("F_address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("F_address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("F_address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andTradeIsNull() {
            addCriterion("F_trade is null");
            return (Criteria) this;
        }

        public Criteria andTradeIsNotNull() {
            addCriterion("F_trade is not null");
            return (Criteria) this;
        }

        public Criteria andTradeEqualTo(String value) {
            addCriterion("F_trade =", value, "trade");
            return (Criteria) this;
        }

        public Criteria andTradeNotEqualTo(String value) {
            addCriterion("F_trade <>", value, "trade");
            return (Criteria) this;
        }

        public Criteria andTradeGreaterThan(String value) {
            addCriterion("F_trade >", value, "trade");
            return (Criteria) this;
        }

        public Criteria andTradeGreaterThanOrEqualTo(String value) {
            addCriterion("F_trade >=", value, "trade");
            return (Criteria) this;
        }

        public Criteria andTradeLessThan(String value) {
            addCriterion("F_trade <", value, "trade");
            return (Criteria) this;
        }

        public Criteria andTradeLessThanOrEqualTo(String value) {
            addCriterion("F_trade <=", value, "trade");
            return (Criteria) this;
        }

        public Criteria andTradeLike(String value) {
            addCriterion("F_trade like", value, "trade");
            return (Criteria) this;
        }

        public Criteria andTradeNotLike(String value) {
            addCriterion("F_trade not like", value, "trade");
            return (Criteria) this;
        }

        public Criteria andTradeIn(List<String> values) {
            addCriterion("F_trade in", values, "trade");
            return (Criteria) this;
        }

        public Criteria andTradeNotIn(List<String> values) {
            addCriterion("F_trade not in", values, "trade");
            return (Criteria) this;
        }

        public Criteria andTradeBetween(String value1, String value2) {
            addCriterion("F_trade between", value1, value2, "trade");
            return (Criteria) this;
        }

        public Criteria andTradeNotBetween(String value1, String value2) {
            addCriterion("F_trade not between", value1, value2, "trade");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("F_email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("F_email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("F_email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("F_email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("F_email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("F_email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("F_email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("F_email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("F_email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("F_email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("F_email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("F_email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("F_email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("F_email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNull() {
            addCriterion("F_bank_name is null");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNotNull() {
            addCriterion("F_bank_name is not null");
            return (Criteria) this;
        }

        public Criteria andBankNameEqualTo(String value) {
            addCriterion("F_bank_name =", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotEqualTo(String value) {
            addCriterion("F_bank_name <>", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThan(String value) {
            addCriterion("F_bank_name >", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("F_bank_name >=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThan(String value) {
            addCriterion("F_bank_name <", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThanOrEqualTo(String value) {
            addCriterion("F_bank_name <=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLike(String value) {
            addCriterion("F_bank_name like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotLike(String value) {
            addCriterion("F_bank_name not like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameIn(List<String> values) {
            addCriterion("F_bank_name in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotIn(List<String> values) {
            addCriterion("F_bank_name not in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameBetween(String value1, String value2) {
            addCriterion("F_bank_name between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotBetween(String value1, String value2) {
            addCriterion("F_bank_name not between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankBranchIsNull() {
            addCriterion("F_bank_branch is null");
            return (Criteria) this;
        }

        public Criteria andBankBranchIsNotNull() {
            addCriterion("F_bank_branch is not null");
            return (Criteria) this;
        }

        public Criteria andBankBranchEqualTo(String value) {
            addCriterion("F_bank_branch =", value, "bankBranch");
            return (Criteria) this;
        }

        public Criteria andBankBranchNotEqualTo(String value) {
            addCriterion("F_bank_branch <>", value, "bankBranch");
            return (Criteria) this;
        }

        public Criteria andBankBranchGreaterThan(String value) {
            addCriterion("F_bank_branch >", value, "bankBranch");
            return (Criteria) this;
        }

        public Criteria andBankBranchGreaterThanOrEqualTo(String value) {
            addCriterion("F_bank_branch >=", value, "bankBranch");
            return (Criteria) this;
        }

        public Criteria andBankBranchLessThan(String value) {
            addCriterion("F_bank_branch <", value, "bankBranch");
            return (Criteria) this;
        }

        public Criteria andBankBranchLessThanOrEqualTo(String value) {
            addCriterion("F_bank_branch <=", value, "bankBranch");
            return (Criteria) this;
        }

        public Criteria andBankBranchLike(String value) {
            addCriterion("F_bank_branch like", value, "bankBranch");
            return (Criteria) this;
        }

        public Criteria andBankBranchNotLike(String value) {
            addCriterion("F_bank_branch not like", value, "bankBranch");
            return (Criteria) this;
        }

        public Criteria andBankBranchIn(List<String> values) {
            addCriterion("F_bank_branch in", values, "bankBranch");
            return (Criteria) this;
        }

        public Criteria andBankBranchNotIn(List<String> values) {
            addCriterion("F_bank_branch not in", values, "bankBranch");
            return (Criteria) this;
        }

        public Criteria andBankBranchBetween(String value1, String value2) {
            addCriterion("F_bank_branch between", value1, value2, "bankBranch");
            return (Criteria) this;
        }

        public Criteria andBankBranchNotBetween(String value1, String value2) {
            addCriterion("F_bank_branch not between", value1, value2, "bankBranch");
            return (Criteria) this;
        }

        public Criteria andBankHolderIsNull() {
            addCriterion("F_bank_holder is null");
            return (Criteria) this;
        }

        public Criteria andBankHolderIsNotNull() {
            addCriterion("F_bank_holder is not null");
            return (Criteria) this;
        }

        public Criteria andBankHolderEqualTo(String value) {
            addCriterion("F_bank_holder =", value, "bankHolder");
            return (Criteria) this;
        }

        public Criteria andBankHolderNotEqualTo(String value) {
            addCriterion("F_bank_holder <>", value, "bankHolder");
            return (Criteria) this;
        }

        public Criteria andBankHolderGreaterThan(String value) {
            addCriterion("F_bank_holder >", value, "bankHolder");
            return (Criteria) this;
        }

        public Criteria andBankHolderGreaterThanOrEqualTo(String value) {
            addCriterion("F_bank_holder >=", value, "bankHolder");
            return (Criteria) this;
        }

        public Criteria andBankHolderLessThan(String value) {
            addCriterion("F_bank_holder <", value, "bankHolder");
            return (Criteria) this;
        }

        public Criteria andBankHolderLessThanOrEqualTo(String value) {
            addCriterion("F_bank_holder <=", value, "bankHolder");
            return (Criteria) this;
        }

        public Criteria andBankHolderLike(String value) {
            addCriterion("F_bank_holder like", value, "bankHolder");
            return (Criteria) this;
        }

        public Criteria andBankHolderNotLike(String value) {
            addCriterion("F_bank_holder not like", value, "bankHolder");
            return (Criteria) this;
        }

        public Criteria andBankHolderIn(List<String> values) {
            addCriterion("F_bank_holder in", values, "bankHolder");
            return (Criteria) this;
        }

        public Criteria andBankHolderNotIn(List<String> values) {
            addCriterion("F_bank_holder not in", values, "bankHolder");
            return (Criteria) this;
        }

        public Criteria andBankHolderBetween(String value1, String value2) {
            addCriterion("F_bank_holder between", value1, value2, "bankHolder");
            return (Criteria) this;
        }

        public Criteria andBankHolderNotBetween(String value1, String value2) {
            addCriterion("F_bank_holder not between", value1, value2, "bankHolder");
            return (Criteria) this;
        }

        public Criteria andBankAccountIsNull() {
            addCriterion("F_bank_account is null");
            return (Criteria) this;
        }

        public Criteria andBankAccountIsNotNull() {
            addCriterion("F_bank_account is not null");
            return (Criteria) this;
        }

        public Criteria andBankAccountEqualTo(String value) {
            addCriterion("F_bank_account =", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotEqualTo(String value) {
            addCriterion("F_bank_account <>", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountGreaterThan(String value) {
            addCriterion("F_bank_account >", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountGreaterThanOrEqualTo(String value) {
            addCriterion("F_bank_account >=", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLessThan(String value) {
            addCriterion("F_bank_account <", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLessThanOrEqualTo(String value) {
            addCriterion("F_bank_account <=", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLike(String value) {
            addCriterion("F_bank_account like", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotLike(String value) {
            addCriterion("F_bank_account not like", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountIn(List<String> values) {
            addCriterion("F_bank_account in", values, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotIn(List<String> values) {
            addCriterion("F_bank_account not in", values, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountBetween(String value1, String value2) {
            addCriterion("F_bank_account between", value1, value2, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotBetween(String value1, String value2) {
            addCriterion("F_bank_account not between", value1, value2, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptIsNull() {
            addCriterion("F_bank_account_encrypt is null");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptIsNotNull() {
            addCriterion("F_bank_account_encrypt is not null");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptEqualTo(String value) {
            addCriterion("F_bank_account_encrypt =", value, "bankAccountEncrypt");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptNotEqualTo(String value) {
            addCriterion("F_bank_account_encrypt <>", value, "bankAccountEncrypt");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptGreaterThan(String value) {
            addCriterion("F_bank_account_encrypt >", value, "bankAccountEncrypt");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptGreaterThanOrEqualTo(String value) {
            addCriterion("F_bank_account_encrypt >=", value, "bankAccountEncrypt");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptLessThan(String value) {
            addCriterion("F_bank_account_encrypt <", value, "bankAccountEncrypt");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptLessThanOrEqualTo(String value) {
            addCriterion("F_bank_account_encrypt <=", value, "bankAccountEncrypt");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptLike(String value) {
            addCriterion("F_bank_account_encrypt like", value, "bankAccountEncrypt");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptNotLike(String value) {
            addCriterion("F_bank_account_encrypt not like", value, "bankAccountEncrypt");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptIn(List<String> values) {
            addCriterion("F_bank_account_encrypt in", values, "bankAccountEncrypt");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptNotIn(List<String> values) {
            addCriterion("F_bank_account_encrypt not in", values, "bankAccountEncrypt");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptBetween(String value1, String value2) {
            addCriterion("F_bank_account_encrypt between", value1, value2, "bankAccountEncrypt");
            return (Criteria) this;
        }

        public Criteria andBankAccountEncryptNotBetween(String value1, String value2) {
            addCriterion("F_bank_account_encrypt not between", value1, value2, "bankAccountEncrypt");
            return (Criteria) this;
        }

        public Criteria andIdcardHandIsNull() {
            addCriterion("F_idcard_hand is null");
            return (Criteria) this;
        }

        public Criteria andIdcardHandIsNotNull() {
            addCriterion("F_idcard_hand is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardHandEqualTo(String value) {
            addCriterion("F_idcard_hand =", value, "idcardHand");
            return (Criteria) this;
        }

        public Criteria andIdcardHandNotEqualTo(String value) {
            addCriterion("F_idcard_hand <>", value, "idcardHand");
            return (Criteria) this;
        }

        public Criteria andIdcardHandGreaterThan(String value) {
            addCriterion("F_idcard_hand >", value, "idcardHand");
            return (Criteria) this;
        }

        public Criteria andIdcardHandGreaterThanOrEqualTo(String value) {
            addCriterion("F_idcard_hand >=", value, "idcardHand");
            return (Criteria) this;
        }

        public Criteria andIdcardHandLessThan(String value) {
            addCriterion("F_idcard_hand <", value, "idcardHand");
            return (Criteria) this;
        }

        public Criteria andIdcardHandLessThanOrEqualTo(String value) {
            addCriterion("F_idcard_hand <=", value, "idcardHand");
            return (Criteria) this;
        }

        public Criteria andIdcardHandLike(String value) {
            addCriterion("F_idcard_hand like", value, "idcardHand");
            return (Criteria) this;
        }

        public Criteria andIdcardHandNotLike(String value) {
            addCriterion("F_idcard_hand not like", value, "idcardHand");
            return (Criteria) this;
        }

        public Criteria andIdcardHandIn(List<String> values) {
            addCriterion("F_idcard_hand in", values, "idcardHand");
            return (Criteria) this;
        }

        public Criteria andIdcardHandNotIn(List<String> values) {
            addCriterion("F_idcard_hand not in", values, "idcardHand");
            return (Criteria) this;
        }

        public Criteria andIdcardHandBetween(String value1, String value2) {
            addCriterion("F_idcard_hand between", value1, value2, "idcardHand");
            return (Criteria) this;
        }

        public Criteria andIdcardHandNotBetween(String value1, String value2) {
            addCriterion("F_idcard_hand not between", value1, value2, "idcardHand");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontIsNull() {
            addCriterion("F_idcard_front is null");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontIsNotNull() {
            addCriterion("F_idcard_front is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontEqualTo(String value) {
            addCriterion("F_idcard_front =", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontNotEqualTo(String value) {
            addCriterion("F_idcard_front <>", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontGreaterThan(String value) {
            addCriterion("F_idcard_front >", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontGreaterThanOrEqualTo(String value) {
            addCriterion("F_idcard_front >=", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontLessThan(String value) {
            addCriterion("F_idcard_front <", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontLessThanOrEqualTo(String value) {
            addCriterion("F_idcard_front <=", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontLike(String value) {
            addCriterion("F_idcard_front like", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontNotLike(String value) {
            addCriterion("F_idcard_front not like", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontIn(List<String> values) {
            addCriterion("F_idcard_front in", values, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontNotIn(List<String> values) {
            addCriterion("F_idcard_front not in", values, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontBetween(String value1, String value2) {
            addCriterion("F_idcard_front between", value1, value2, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontNotBetween(String value1, String value2) {
            addCriterion("F_idcard_front not between", value1, value2, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardBackIsNull() {
            addCriterion("F_idcard_back is null");
            return (Criteria) this;
        }

        public Criteria andIdcardBackIsNotNull() {
            addCriterion("F_idcard_back is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardBackEqualTo(String value) {
            addCriterion("F_idcard_back =", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackNotEqualTo(String value) {
            addCriterion("F_idcard_back <>", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackGreaterThan(String value) {
            addCriterion("F_idcard_back >", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackGreaterThanOrEqualTo(String value) {
            addCriterion("F_idcard_back >=", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackLessThan(String value) {
            addCriterion("F_idcard_back <", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackLessThanOrEqualTo(String value) {
            addCriterion("F_idcard_back <=", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackLike(String value) {
            addCriterion("F_idcard_back like", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackNotLike(String value) {
            addCriterion("F_idcard_back not like", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackIn(List<String> values) {
            addCriterion("F_idcard_back in", values, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackNotIn(List<String> values) {
            addCriterion("F_idcard_back not in", values, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackBetween(String value1, String value2) {
            addCriterion("F_idcard_back between", value1, value2, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackNotBetween(String value1, String value2) {
            addCriterion("F_idcard_back not between", value1, value2, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseIsNull() {
            addCriterion("F_business_license is null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseIsNotNull() {
            addCriterion("F_business_license is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseEqualTo(String value) {
            addCriterion("F_business_license =", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNotEqualTo(String value) {
            addCriterion("F_business_license <>", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseGreaterThan(String value) {
            addCriterion("F_business_license >", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseGreaterThanOrEqualTo(String value) {
            addCriterion("F_business_license >=", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseLessThan(String value) {
            addCriterion("F_business_license <", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseLessThanOrEqualTo(String value) {
            addCriterion("F_business_license <=", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseLike(String value) {
            addCriterion("F_business_license like", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNotLike(String value) {
            addCriterion("F_business_license not like", value, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseIn(List<String> values) {
            addCriterion("F_business_license in", values, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNotIn(List<String> values) {
            addCriterion("F_business_license not in", values, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseBetween(String value1, String value2) {
            addCriterion("F_business_license between", value1, value2, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNotBetween(String value1, String value2) {
            addCriterion("F_business_license not between", value1, value2, "businessLicense");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameIsNull() {
            addCriterion("F_business_license_name is null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameIsNotNull() {
            addCriterion("F_business_license_name is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameEqualTo(String value) {
            addCriterion("F_business_license_name =", value, "businessLicenseName");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameNotEqualTo(String value) {
            addCriterion("F_business_license_name <>", value, "businessLicenseName");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameGreaterThan(String value) {
            addCriterion("F_business_license_name >", value, "businessLicenseName");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameGreaterThanOrEqualTo(String value) {
            addCriterion("F_business_license_name >=", value, "businessLicenseName");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameLessThan(String value) {
            addCriterion("F_business_license_name <", value, "businessLicenseName");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameLessThanOrEqualTo(String value) {
            addCriterion("F_business_license_name <=", value, "businessLicenseName");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameLike(String value) {
            addCriterion("F_business_license_name like", value, "businessLicenseName");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameNotLike(String value) {
            addCriterion("F_business_license_name not like", value, "businessLicenseName");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameIn(List<String> values) {
            addCriterion("F_business_license_name in", values, "businessLicenseName");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameNotIn(List<String> values) {
            addCriterion("F_business_license_name not in", values, "businessLicenseName");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameBetween(String value1, String value2) {
            addCriterion("F_business_license_name between", value1, value2, "businessLicenseName");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseNameNotBetween(String value1, String value2) {
            addCriterion("F_business_license_name not between", value1, value2, "businessLicenseName");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrIsNull() {
            addCriterion("F_business_license_addr is null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrIsNotNull() {
            addCriterion("F_business_license_addr is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrEqualTo(String value) {
            addCriterion("F_business_license_addr =", value, "businessLicenseAddr");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrNotEqualTo(String value) {
            addCriterion("F_business_license_addr <>", value, "businessLicenseAddr");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrGreaterThan(String value) {
            addCriterion("F_business_license_addr >", value, "businessLicenseAddr");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrGreaterThanOrEqualTo(String value) {
            addCriterion("F_business_license_addr >=", value, "businessLicenseAddr");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrLessThan(String value) {
            addCriterion("F_business_license_addr <", value, "businessLicenseAddr");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrLessThanOrEqualTo(String value) {
            addCriterion("F_business_license_addr <=", value, "businessLicenseAddr");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrLike(String value) {
            addCriterion("F_business_license_addr like", value, "businessLicenseAddr");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrNotLike(String value) {
            addCriterion("F_business_license_addr not like", value, "businessLicenseAddr");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrIn(List<String> values) {
            addCriterion("F_business_license_addr in", values, "businessLicenseAddr");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrNotIn(List<String> values) {
            addCriterion("F_business_license_addr not in", values, "businessLicenseAddr");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrBetween(String value1, String value2) {
            addCriterion("F_business_license_addr between", value1, value2, "businessLicenseAddr");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseAddrNotBetween(String value1, String value2) {
            addCriterion("F_business_license_addr not between", value1, value2, "businessLicenseAddr");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePIsNull() {
            addCriterion("F_business_license_p is null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePIsNotNull() {
            addCriterion("F_business_license_p is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePEqualTo(String value) {
            addCriterion("F_business_license_p =", value, "businessLicenseP");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePNotEqualTo(String value) {
            addCriterion("F_business_license_p <>", value, "businessLicenseP");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePGreaterThan(String value) {
            addCriterion("F_business_license_p >", value, "businessLicenseP");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePGreaterThanOrEqualTo(String value) {
            addCriterion("F_business_license_p >=", value, "businessLicenseP");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePLessThan(String value) {
            addCriterion("F_business_license_p <", value, "businessLicenseP");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePLessThanOrEqualTo(String value) {
            addCriterion("F_business_license_p <=", value, "businessLicenseP");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePLike(String value) {
            addCriterion("F_business_license_p like", value, "businessLicenseP");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePNotLike(String value) {
            addCriterion("F_business_license_p not like", value, "businessLicenseP");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePIn(List<String> values) {
            addCriterion("F_business_license_p in", values, "businessLicenseP");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePNotIn(List<String> values) {
            addCriterion("F_business_license_p not in", values, "businessLicenseP");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePBetween(String value1, String value2) {
            addCriterion("F_business_license_p between", value1, value2, "businessLicenseP");
            return (Criteria) this;
        }

        public Criteria andBusinessLicensePNotBetween(String value1, String value2) {
            addCriterion("F_business_license_p not between", value1, value2, "businessLicenseP");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCIsNull() {
            addCriterion("F_business_license_c is null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCIsNotNull() {
            addCriterion("F_business_license_c is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCEqualTo(String value) {
            addCriterion("F_business_license_c =", value, "businessLicenseC");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCNotEqualTo(String value) {
            addCriterion("F_business_license_c <>", value, "businessLicenseC");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCGreaterThan(String value) {
            addCriterion("F_business_license_c >", value, "businessLicenseC");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCGreaterThanOrEqualTo(String value) {
            addCriterion("F_business_license_c >=", value, "businessLicenseC");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCLessThan(String value) {
            addCriterion("F_business_license_c <", value, "businessLicenseC");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCLessThanOrEqualTo(String value) {
            addCriterion("F_business_license_c <=", value, "businessLicenseC");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCLike(String value) {
            addCriterion("F_business_license_c like", value, "businessLicenseC");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCNotLike(String value) {
            addCriterion("F_business_license_c not like", value, "businessLicenseC");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCIn(List<String> values) {
            addCriterion("F_business_license_c in", values, "businessLicenseC");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCNotIn(List<String> values) {
            addCriterion("F_business_license_c not in", values, "businessLicenseC");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCBetween(String value1, String value2) {
            addCriterion("F_business_license_c between", value1, value2, "businessLicenseC");
            return (Criteria) this;
        }

        public Criteria andBusinessLicenseCNotBetween(String value1, String value2) {
            addCriterion("F_business_license_c not between", value1, value2, "businessLicenseC");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideIsNull() {
            addCriterion("F_business_inside is null");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideIsNotNull() {
            addCriterion("F_business_inside is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideEqualTo(String value) {
            addCriterion("F_business_inside =", value, "businessInside");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideNotEqualTo(String value) {
            addCriterion("F_business_inside <>", value, "businessInside");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideGreaterThan(String value) {
            addCriterion("F_business_inside >", value, "businessInside");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideGreaterThanOrEqualTo(String value) {
            addCriterion("F_business_inside >=", value, "businessInside");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideLessThan(String value) {
            addCriterion("F_business_inside <", value, "businessInside");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideLessThanOrEqualTo(String value) {
            addCriterion("F_business_inside <=", value, "businessInside");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideLike(String value) {
            addCriterion("F_business_inside like", value, "businessInside");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideNotLike(String value) {
            addCriterion("F_business_inside not like", value, "businessInside");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideIn(List<String> values) {
            addCriterion("F_business_inside in", values, "businessInside");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideNotIn(List<String> values) {
            addCriterion("F_business_inside not in", values, "businessInside");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideBetween(String value1, String value2) {
            addCriterion("F_business_inside between", value1, value2, "businessInside");
            return (Criteria) this;
        }

        public Criteria andBusinessInsideNotBetween(String value1, String value2) {
            addCriterion("F_business_inside not between", value1, value2, "businessInside");
            return (Criteria) this;
        }

        public Criteria andRentProtocolIsNull() {
            addCriterion("F_rent_protocol is null");
            return (Criteria) this;
        }

        public Criteria andRentProtocolIsNotNull() {
            addCriterion("F_rent_protocol is not null");
            return (Criteria) this;
        }

        public Criteria andRentProtocolEqualTo(String value) {
            addCriterion("F_rent_protocol =", value, "rentProtocol");
            return (Criteria) this;
        }

        public Criteria andRentProtocolNotEqualTo(String value) {
            addCriterion("F_rent_protocol <>", value, "rentProtocol");
            return (Criteria) this;
        }

        public Criteria andRentProtocolGreaterThan(String value) {
            addCriterion("F_rent_protocol >", value, "rentProtocol");
            return (Criteria) this;
        }

        public Criteria andRentProtocolGreaterThanOrEqualTo(String value) {
            addCriterion("F_rent_protocol >=", value, "rentProtocol");
            return (Criteria) this;
        }

        public Criteria andRentProtocolLessThan(String value) {
            addCriterion("F_rent_protocol <", value, "rentProtocol");
            return (Criteria) this;
        }

        public Criteria andRentProtocolLessThanOrEqualTo(String value) {
            addCriterion("F_rent_protocol <=", value, "rentProtocol");
            return (Criteria) this;
        }

        public Criteria andRentProtocolLike(String value) {
            addCriterion("F_rent_protocol like", value, "rentProtocol");
            return (Criteria) this;
        }

        public Criteria andRentProtocolNotLike(String value) {
            addCriterion("F_rent_protocol not like", value, "rentProtocol");
            return (Criteria) this;
        }

        public Criteria andRentProtocolIn(List<String> values) {
            addCriterion("F_rent_protocol in", values, "rentProtocol");
            return (Criteria) this;
        }

        public Criteria andRentProtocolNotIn(List<String> values) {
            addCriterion("F_rent_protocol not in", values, "rentProtocol");
            return (Criteria) this;
        }

        public Criteria andRentProtocolBetween(String value1, String value2) {
            addCriterion("F_rent_protocol between", value1, value2, "rentProtocol");
            return (Criteria) this;
        }

        public Criteria andRentProtocolNotBetween(String value1, String value2) {
            addCriterion("F_rent_protocol not between", value1, value2, "rentProtocol");
            return (Criteria) this;
        }

        public Criteria andGoodsIsNull() {
            addCriterion("F_goods is null");
            return (Criteria) this;
        }

        public Criteria andGoodsIsNotNull() {
            addCriterion("F_goods is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsEqualTo(String value) {
            addCriterion("F_goods =", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsNotEqualTo(String value) {
            addCriterion("F_goods <>", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsGreaterThan(String value) {
            addCriterion("F_goods >", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsGreaterThanOrEqualTo(String value) {
            addCriterion("F_goods >=", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsLessThan(String value) {
            addCriterion("F_goods <", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsLessThanOrEqualTo(String value) {
            addCriterion("F_goods <=", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsLike(String value) {
            addCriterion("F_goods like", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsNotLike(String value) {
            addCriterion("F_goods not like", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsIn(List<String> values) {
            addCriterion("F_goods in", values, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsNotIn(List<String> values) {
            addCriterion("F_goods not in", values, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsBetween(String value1, String value2) {
            addCriterion("F_goods between", value1, value2, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsNotBetween(String value1, String value2) {
            addCriterion("F_goods not between", value1, value2, "goods");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("F_create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("F_create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("F_create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("F_create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("F_create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("F_create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("F_create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("F_create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("F_create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("F_create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("F_create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("F_create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andChkTimeIsNull() {
            addCriterion("F_chk_time is null");
            return (Criteria) this;
        }

        public Criteria andChkTimeIsNotNull() {
            addCriterion("F_chk_time is not null");
            return (Criteria) this;
        }

        public Criteria andChkTimeEqualTo(Date value) {
            addCriterion("F_chk_time =", value, "chkTime");
            return (Criteria) this;
        }

        public Criteria andChkTimeNotEqualTo(Date value) {
            addCriterion("F_chk_time <>", value, "chkTime");
            return (Criteria) this;
        }

        public Criteria andChkTimeGreaterThan(Date value) {
            addCriterion("F_chk_time >", value, "chkTime");
            return (Criteria) this;
        }

        public Criteria andChkTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("F_chk_time >=", value, "chkTime");
            return (Criteria) this;
        }

        public Criteria andChkTimeLessThan(Date value) {
            addCriterion("F_chk_time <", value, "chkTime");
            return (Criteria) this;
        }

        public Criteria andChkTimeLessThanOrEqualTo(Date value) {
            addCriterion("F_chk_time <=", value, "chkTime");
            return (Criteria) this;
        }

        public Criteria andChkTimeIn(List<Date> values) {
            addCriterion("F_chk_time in", values, "chkTime");
            return (Criteria) this;
        }

        public Criteria andChkTimeNotIn(List<Date> values) {
            addCriterion("F_chk_time not in", values, "chkTime");
            return (Criteria) this;
        }

        public Criteria andChkTimeBetween(Date value1, Date value2) {
            addCriterion("F_chk_time between", value1, value2, "chkTime");
            return (Criteria) this;
        }

        public Criteria andChkTimeNotBetween(Date value1, Date value2) {
            addCriterion("F_chk_time not between", value1, value2, "chkTime");
            return (Criteria) this;
        }

        public Criteria andStepIsNull() {
            addCriterion("F_step is null");
            return (Criteria) this;
        }

        public Criteria andStepIsNotNull() {
            addCriterion("F_step is not null");
            return (Criteria) this;
        }

        public Criteria andStepEqualTo(Integer value) {
            addCriterion("F_step =", value, "step");
            return (Criteria) this;
        }

        public Criteria andStepNotEqualTo(Integer value) {
            addCriterion("F_step <>", value, "step");
            return (Criteria) this;
        }

        public Criteria andStepGreaterThan(Integer value) {
            addCriterion("F_step >", value, "step");
            return (Criteria) this;
        }

        public Criteria andStepGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_step >=", value, "step");
            return (Criteria) this;
        }

        public Criteria andStepLessThan(Integer value) {
            addCriterion("F_step <", value, "step");
            return (Criteria) this;
        }

        public Criteria andStepLessThanOrEqualTo(Integer value) {
            addCriterion("F_step <=", value, "step");
            return (Criteria) this;
        }

        public Criteria andStepIn(List<Integer> values) {
            addCriterion("F_step in", values, "step");
            return (Criteria) this;
        }

        public Criteria andStepNotIn(List<Integer> values) {
            addCriterion("F_step not in", values, "step");
            return (Criteria) this;
        }

        public Criteria andStepBetween(Integer value1, Integer value2) {
            addCriterion("F_step between", value1, value2, "step");
            return (Criteria) this;
        }

        public Criteria andStepNotBetween(Integer value1, Integer value2) {
            addCriterion("F_step not between", value1, value2, "step");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("F_status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("F_status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("F_status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("F_status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("F_status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("F_status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("F_status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("F_status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("F_status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("F_status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("F_status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andAgentIdIsNull() {
            addCriterion("F_agent_id is null");
            return (Criteria) this;
        }

        public Criteria andAgentIdIsNotNull() {
            addCriterion("F_agent_id is not null");
            return (Criteria) this;
        }

        public Criteria andAgentIdEqualTo(String value) {
            addCriterion("F_agent_id =", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotEqualTo(String value) {
            addCriterion("F_agent_id <>", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdGreaterThan(String value) {
            addCriterion("F_agent_id >", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdGreaterThanOrEqualTo(String value) {
            addCriterion("F_agent_id >=", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdLessThan(String value) {
            addCriterion("F_agent_id <", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdLessThanOrEqualTo(String value) {
            addCriterion("F_agent_id <=", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdLike(String value) {
            addCriterion("F_agent_id like", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotLike(String value) {
            addCriterion("F_agent_id not like", value, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdIn(List<String> values) {
            addCriterion("F_agent_id in", values, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotIn(List<String> values) {
            addCriterion("F_agent_id not in", values, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdBetween(String value1, String value2) {
            addCriterion("F_agent_id between", value1, value2, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentIdNotBetween(String value1, String value2) {
            addCriterion("F_agent_id not between", value1, value2, "agentId");
            return (Criteria) this;
        }

        public Criteria andAgentId1gIsNull() {
            addCriterion("F_agent_id_1g is null");
            return (Criteria) this;
        }

        public Criteria andAgentId1gIsNotNull() {
            addCriterion("F_agent_id_1g is not null");
            return (Criteria) this;
        }

        public Criteria andAgentId1gEqualTo(Integer value) {
            addCriterion("F_agent_id_1g =", value, "agentId1g");
            return (Criteria) this;
        }

        public Criteria andAgentId1gNotEqualTo(Integer value) {
            addCriterion("F_agent_id_1g <>", value, "agentId1g");
            return (Criteria) this;
        }

        public Criteria andAgentId1gGreaterThan(Integer value) {
            addCriterion("F_agent_id_1g >", value, "agentId1g");
            return (Criteria) this;
        }

        public Criteria andAgentId1gGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_agent_id_1g >=", value, "agentId1g");
            return (Criteria) this;
        }

        public Criteria andAgentId1gLessThan(Integer value) {
            addCriterion("F_agent_id_1g <", value, "agentId1g");
            return (Criteria) this;
        }

        public Criteria andAgentId1gLessThanOrEqualTo(Integer value) {
            addCriterion("F_agent_id_1g <=", value, "agentId1g");
            return (Criteria) this;
        }

        public Criteria andAgentId1gIn(List<Integer> values) {
            addCriterion("F_agent_id_1g in", values, "agentId1g");
            return (Criteria) this;
        }

        public Criteria andAgentId1gNotIn(List<Integer> values) {
            addCriterion("F_agent_id_1g not in", values, "agentId1g");
            return (Criteria) this;
        }

        public Criteria andAgentId1gBetween(Integer value1, Integer value2) {
            addCriterion("F_agent_id_1g between", value1, value2, "agentId1g");
            return (Criteria) this;
        }

        public Criteria andAgentId1gNotBetween(Integer value1, Integer value2) {
            addCriterion("F_agent_id_1g not between", value1, value2, "agentId1g");
            return (Criteria) this;
        }

        public Criteria andAgentId2gIsNull() {
            addCriterion("F_agent_id_2g is null");
            return (Criteria) this;
        }

        public Criteria andAgentId2gIsNotNull() {
            addCriterion("F_agent_id_2g is not null");
            return (Criteria) this;
        }

        public Criteria andAgentId2gEqualTo(Integer value) {
            addCriterion("F_agent_id_2g =", value, "agentId2g");
            return (Criteria) this;
        }

        public Criteria andAgentId2gNotEqualTo(Integer value) {
            addCriterion("F_agent_id_2g <>", value, "agentId2g");
            return (Criteria) this;
        }

        public Criteria andAgentId2gGreaterThan(Integer value) {
            addCriterion("F_agent_id_2g >", value, "agentId2g");
            return (Criteria) this;
        }

        public Criteria andAgentId2gGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_agent_id_2g >=", value, "agentId2g");
            return (Criteria) this;
        }

        public Criteria andAgentId2gLessThan(Integer value) {
            addCriterion("F_agent_id_2g <", value, "agentId2g");
            return (Criteria) this;
        }

        public Criteria andAgentId2gLessThanOrEqualTo(Integer value) {
            addCriterion("F_agent_id_2g <=", value, "agentId2g");
            return (Criteria) this;
        }

        public Criteria andAgentId2gIn(List<Integer> values) {
            addCriterion("F_agent_id_2g in", values, "agentId2g");
            return (Criteria) this;
        }

        public Criteria andAgentId2gNotIn(List<Integer> values) {
            addCriterion("F_agent_id_2g not in", values, "agentId2g");
            return (Criteria) this;
        }

        public Criteria andAgentId2gBetween(Integer value1, Integer value2) {
            addCriterion("F_agent_id_2g between", value1, value2, "agentId2g");
            return (Criteria) this;
        }

        public Criteria andAgentId2gNotBetween(Integer value1, Integer value2) {
            addCriterion("F_agent_id_2g not between", value1, value2, "agentId2g");
            return (Criteria) this;
        }

        public Criteria andAgentId3gIsNull() {
            addCriterion("F_agent_id_3g is null");
            return (Criteria) this;
        }

        public Criteria andAgentId3gIsNotNull() {
            addCriterion("F_agent_id_3g is not null");
            return (Criteria) this;
        }

        public Criteria andAgentId3gEqualTo(Integer value) {
            addCriterion("F_agent_id_3g =", value, "agentId3g");
            return (Criteria) this;
        }

        public Criteria andAgentId3gNotEqualTo(Integer value) {
            addCriterion("F_agent_id_3g <>", value, "agentId3g");
            return (Criteria) this;
        }

        public Criteria andAgentId3gGreaterThan(Integer value) {
            addCriterion("F_agent_id_3g >", value, "agentId3g");
            return (Criteria) this;
        }

        public Criteria andAgentId3gGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_agent_id_3g >=", value, "agentId3g");
            return (Criteria) this;
        }

        public Criteria andAgentId3gLessThan(Integer value) {
            addCriterion("F_agent_id_3g <", value, "agentId3g");
            return (Criteria) this;
        }

        public Criteria andAgentId3gLessThanOrEqualTo(Integer value) {
            addCriterion("F_agent_id_3g <=", value, "agentId3g");
            return (Criteria) this;
        }

        public Criteria andAgentId3gIn(List<Integer> values) {
            addCriterion("F_agent_id_3g in", values, "agentId3g");
            return (Criteria) this;
        }

        public Criteria andAgentId3gNotIn(List<Integer> values) {
            addCriterion("F_agent_id_3g not in", values, "agentId3g");
            return (Criteria) this;
        }

        public Criteria andAgentId3gBetween(Integer value1, Integer value2) {
            addCriterion("F_agent_id_3g between", value1, value2, "agentId3g");
            return (Criteria) this;
        }

        public Criteria andAgentId3gNotBetween(Integer value1, Integer value2) {
            addCriterion("F_agent_id_3g not between", value1, value2, "agentId3g");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNull() {
            addCriterion("F_commission is null");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNotNull() {
            addCriterion("F_commission is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionEqualTo(Integer value) {
            addCriterion("F_commission =", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotEqualTo(Integer value) {
            addCriterion("F_commission <>", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThan(Integer value) {
            addCriterion("F_commission >", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_commission >=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThan(Integer value) {
            addCriterion("F_commission <", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThanOrEqualTo(Integer value) {
            addCriterion("F_commission <=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionIn(List<Integer> values) {
            addCriterion("F_commission in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotIn(List<Integer> values) {
            addCriterion("F_commission not in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionBetween(Integer value1, Integer value2) {
            addCriterion("F_commission between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotBetween(Integer value1, Integer value2) {
            addCriterion("F_commission not between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andMaxCommissionOneTransactionIsNull() {
            addCriterion("F_max_commission_one_transaction is null");
            return (Criteria) this;
        }

        public Criteria andMaxCommissionOneTransactionIsNotNull() {
            addCriterion("F_max_commission_one_transaction is not null");
            return (Criteria) this;
        }

        public Criteria andMaxCommissionOneTransactionEqualTo(Integer value) {
            addCriterion("F_max_commission_one_transaction =", value, "maxCommissionOneTransaction");
            return (Criteria) this;
        }

        public Criteria andMaxCommissionOneTransactionNotEqualTo(Integer value) {
            addCriterion("F_max_commission_one_transaction <>", value, "maxCommissionOneTransaction");
            return (Criteria) this;
        }

        public Criteria andMaxCommissionOneTransactionGreaterThan(Integer value) {
            addCriterion("F_max_commission_one_transaction >", value, "maxCommissionOneTransaction");
            return (Criteria) this;
        }

        public Criteria andMaxCommissionOneTransactionGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_max_commission_one_transaction >=", value, "maxCommissionOneTransaction");
            return (Criteria) this;
        }

        public Criteria andMaxCommissionOneTransactionLessThan(Integer value) {
            addCriterion("F_max_commission_one_transaction <", value, "maxCommissionOneTransaction");
            return (Criteria) this;
        }

        public Criteria andMaxCommissionOneTransactionLessThanOrEqualTo(Integer value) {
            addCriterion("F_max_commission_one_transaction <=", value, "maxCommissionOneTransaction");
            return (Criteria) this;
        }

        public Criteria andMaxCommissionOneTransactionIn(List<Integer> values) {
            addCriterion("F_max_commission_one_transaction in", values, "maxCommissionOneTransaction");
            return (Criteria) this;
        }

        public Criteria andMaxCommissionOneTransactionNotIn(List<Integer> values) {
            addCriterion("F_max_commission_one_transaction not in", values, "maxCommissionOneTransaction");
            return (Criteria) this;
        }

        public Criteria andMaxCommissionOneTransactionBetween(Integer value1, Integer value2) {
            addCriterion("F_max_commission_one_transaction between", value1, value2, "maxCommissionOneTransaction");
            return (Criteria) this;
        }

        public Criteria andMaxCommissionOneTransactionNotBetween(Integer value1, Integer value2) {
            addCriterion("F_max_commission_one_transaction not between", value1, value2, "maxCommissionOneTransaction");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontIsNull() {
            addCriterion("F_bankcard_front is null");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontIsNotNull() {
            addCriterion("F_bankcard_front is not null");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontEqualTo(String value) {
            addCriterion("F_bankcard_front =", value, "bankcardFront");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontNotEqualTo(String value) {
            addCriterion("F_bankcard_front <>", value, "bankcardFront");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontGreaterThan(String value) {
            addCriterion("F_bankcard_front >", value, "bankcardFront");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontGreaterThanOrEqualTo(String value) {
            addCriterion("F_bankcard_front >=", value, "bankcardFront");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontLessThan(String value) {
            addCriterion("F_bankcard_front <", value, "bankcardFront");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontLessThanOrEqualTo(String value) {
            addCriterion("F_bankcard_front <=", value, "bankcardFront");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontLike(String value) {
            addCriterion("F_bankcard_front like", value, "bankcardFront");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontNotLike(String value) {
            addCriterion("F_bankcard_front not like", value, "bankcardFront");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontIn(List<String> values) {
            addCriterion("F_bankcard_front in", values, "bankcardFront");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontNotIn(List<String> values) {
            addCriterion("F_bankcard_front not in", values, "bankcardFront");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontBetween(String value1, String value2) {
            addCriterion("F_bankcard_front between", value1, value2, "bankcardFront");
            return (Criteria) this;
        }

        public Criteria andBankcardFrontNotBetween(String value1, String value2) {
            addCriterion("F_bankcard_front not between", value1, value2, "bankcardFront");
            return (Criteria) this;
        }

        public Criteria andBankcardBackIsNull() {
            addCriterion("F_bankcard_back is null");
            return (Criteria) this;
        }

        public Criteria andBankcardBackIsNotNull() {
            addCriterion("F_bankcard_back is not null");
            return (Criteria) this;
        }

        public Criteria andBankcardBackEqualTo(String value) {
            addCriterion("F_bankcard_back =", value, "bankcardBack");
            return (Criteria) this;
        }

        public Criteria andBankcardBackNotEqualTo(String value) {
            addCriterion("F_bankcard_back <>", value, "bankcardBack");
            return (Criteria) this;
        }

        public Criteria andBankcardBackGreaterThan(String value) {
            addCriterion("F_bankcard_back >", value, "bankcardBack");
            return (Criteria) this;
        }

        public Criteria andBankcardBackGreaterThanOrEqualTo(String value) {
            addCriterion("F_bankcard_back >=", value, "bankcardBack");
            return (Criteria) this;
        }

        public Criteria andBankcardBackLessThan(String value) {
            addCriterion("F_bankcard_back <", value, "bankcardBack");
            return (Criteria) this;
        }

        public Criteria andBankcardBackLessThanOrEqualTo(String value) {
            addCriterion("F_bankcard_back <=", value, "bankcardBack");
            return (Criteria) this;
        }

        public Criteria andBankcardBackLike(String value) {
            addCriterion("F_bankcard_back like", value, "bankcardBack");
            return (Criteria) this;
        }

        public Criteria andBankcardBackNotLike(String value) {
            addCriterion("F_bankcard_back not like", value, "bankcardBack");
            return (Criteria) this;
        }

        public Criteria andBankcardBackIn(List<String> values) {
            addCriterion("F_bankcard_back in", values, "bankcardBack");
            return (Criteria) this;
        }

        public Criteria andBankcardBackNotIn(List<String> values) {
            addCriterion("F_bankcard_back not in", values, "bankcardBack");
            return (Criteria) this;
        }

        public Criteria andBankcardBackBetween(String value1, String value2) {
            addCriterion("F_bankcard_back between", value1, value2, "bankcardBack");
            return (Criteria) this;
        }

        public Criteria andBankcardBackNotBetween(String value1, String value2) {
            addCriterion("F_bankcard_back not between", value1, value2, "bankcardBack");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoIsNull() {
            addCriterion("F_door_photo is null");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoIsNotNull() {
            addCriterion("F_door_photo is not null");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoEqualTo(String value) {
            addCriterion("F_door_photo =", value, "doorPhoto");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoNotEqualTo(String value) {
            addCriterion("F_door_photo <>", value, "doorPhoto");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoGreaterThan(String value) {
            addCriterion("F_door_photo >", value, "doorPhoto");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoGreaterThanOrEqualTo(String value) {
            addCriterion("F_door_photo >=", value, "doorPhoto");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoLessThan(String value) {
            addCriterion("F_door_photo <", value, "doorPhoto");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoLessThanOrEqualTo(String value) {
            addCriterion("F_door_photo <=", value, "doorPhoto");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoLike(String value) {
            addCriterion("F_door_photo like", value, "doorPhoto");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoNotLike(String value) {
            addCriterion("F_door_photo not like", value, "doorPhoto");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoIn(List<String> values) {
            addCriterion("F_door_photo in", values, "doorPhoto");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoNotIn(List<String> values) {
            addCriterion("F_door_photo not in", values, "doorPhoto");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoBetween(String value1, String value2) {
            addCriterion("F_door_photo between", value1, value2, "doorPhoto");
            return (Criteria) this;
        }

        public Criteria andDoorPhotoNotBetween(String value1, String value2) {
            addCriterion("F_door_photo not between", value1, value2, "doorPhoto");
            return (Criteria) this;
        }

        public Criteria andAddressProveIsNull() {
            addCriterion("F_address_prove is null");
            return (Criteria) this;
        }

        public Criteria andAddressProveIsNotNull() {
            addCriterion("F_address_prove is not null");
            return (Criteria) this;
        }

        public Criteria andAddressProveEqualTo(String value) {
            addCriterion("F_address_prove =", value, "addressProve");
            return (Criteria) this;
        }

        public Criteria andAddressProveNotEqualTo(String value) {
            addCriterion("F_address_prove <>", value, "addressProve");
            return (Criteria) this;
        }

        public Criteria andAddressProveGreaterThan(String value) {
            addCriterion("F_address_prove >", value, "addressProve");
            return (Criteria) this;
        }

        public Criteria andAddressProveGreaterThanOrEqualTo(String value) {
            addCriterion("F_address_prove >=", value, "addressProve");
            return (Criteria) this;
        }

        public Criteria andAddressProveLessThan(String value) {
            addCriterion("F_address_prove <", value, "addressProve");
            return (Criteria) this;
        }

        public Criteria andAddressProveLessThanOrEqualTo(String value) {
            addCriterion("F_address_prove <=", value, "addressProve");
            return (Criteria) this;
        }

        public Criteria andAddressProveLike(String value) {
            addCriterion("F_address_prove like", value, "addressProve");
            return (Criteria) this;
        }

        public Criteria andAddressProveNotLike(String value) {
            addCriterion("F_address_prove not like", value, "addressProve");
            return (Criteria) this;
        }

        public Criteria andAddressProveIn(List<String> values) {
            addCriterion("F_address_prove in", values, "addressProve");
            return (Criteria) this;
        }

        public Criteria andAddressProveNotIn(List<String> values) {
            addCriterion("F_address_prove not in", values, "addressProve");
            return (Criteria) this;
        }

        public Criteria andAddressProveBetween(String value1, String value2) {
            addCriterion("F_address_prove between", value1, value2, "addressProve");
            return (Criteria) this;
        }

        public Criteria andAddressProveNotBetween(String value1, String value2) {
            addCriterion("F_address_prove not between", value1, value2, "addressProve");
            return (Criteria) this;
        }

        public Criteria andNetShopCertIsNull() {
            addCriterion("F_net_shop_cert is null");
            return (Criteria) this;
        }

        public Criteria andNetShopCertIsNotNull() {
            addCriterion("F_net_shop_cert is not null");
            return (Criteria) this;
        }

        public Criteria andNetShopCertEqualTo(String value) {
            addCriterion("F_net_shop_cert =", value, "netShopCert");
            return (Criteria) this;
        }

        public Criteria andNetShopCertNotEqualTo(String value) {
            addCriterion("F_net_shop_cert <>", value, "netShopCert");
            return (Criteria) this;
        }

        public Criteria andNetShopCertGreaterThan(String value) {
            addCriterion("F_net_shop_cert >", value, "netShopCert");
            return (Criteria) this;
        }

        public Criteria andNetShopCertGreaterThanOrEqualTo(String value) {
            addCriterion("F_net_shop_cert >=", value, "netShopCert");
            return (Criteria) this;
        }

        public Criteria andNetShopCertLessThan(String value) {
            addCriterion("F_net_shop_cert <", value, "netShopCert");
            return (Criteria) this;
        }

        public Criteria andNetShopCertLessThanOrEqualTo(String value) {
            addCriterion("F_net_shop_cert <=", value, "netShopCert");
            return (Criteria) this;
        }

        public Criteria andNetShopCertLike(String value) {
            addCriterion("F_net_shop_cert like", value, "netShopCert");
            return (Criteria) this;
        }

        public Criteria andNetShopCertNotLike(String value) {
            addCriterion("F_net_shop_cert not like", value, "netShopCert");
            return (Criteria) this;
        }

        public Criteria andNetShopCertIn(List<String> values) {
            addCriterion("F_net_shop_cert in", values, "netShopCert");
            return (Criteria) this;
        }

        public Criteria andNetShopCertNotIn(List<String> values) {
            addCriterion("F_net_shop_cert not in", values, "netShopCert");
            return (Criteria) this;
        }

        public Criteria andNetShopCertBetween(String value1, String value2) {
            addCriterion("F_net_shop_cert between", value1, value2, "netShopCert");
            return (Criteria) this;
        }

        public Criteria andNetShopCertNotBetween(String value1, String value2) {
            addCriterion("F_net_shop_cert not between", value1, value2, "netShopCert");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertIsNull() {
            addCriterion("F_bank_credit_cert is null");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertIsNotNull() {
            addCriterion("F_bank_credit_cert is not null");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertEqualTo(String value) {
            addCriterion("F_bank_credit_cert =", value, "bankCreditCert");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertNotEqualTo(String value) {
            addCriterion("F_bank_credit_cert <>", value, "bankCreditCert");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertGreaterThan(String value) {
            addCriterion("F_bank_credit_cert >", value, "bankCreditCert");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertGreaterThanOrEqualTo(String value) {
            addCriterion("F_bank_credit_cert >=", value, "bankCreditCert");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertLessThan(String value) {
            addCriterion("F_bank_credit_cert <", value, "bankCreditCert");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertLessThanOrEqualTo(String value) {
            addCriterion("F_bank_credit_cert <=", value, "bankCreditCert");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertLike(String value) {
            addCriterion("F_bank_credit_cert like", value, "bankCreditCert");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertNotLike(String value) {
            addCriterion("F_bank_credit_cert not like", value, "bankCreditCert");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertIn(List<String> values) {
            addCriterion("F_bank_credit_cert in", values, "bankCreditCert");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertNotIn(List<String> values) {
            addCriterion("F_bank_credit_cert not in", values, "bankCreditCert");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertBetween(String value1, String value2) {
            addCriterion("F_bank_credit_cert between", value1, value2, "bankCreditCert");
            return (Criteria) this;
        }

        public Criteria andBankCreditCertNotBetween(String value1, String value2) {
            addCriterion("F_bank_credit_cert not between", value1, value2, "bankCreditCert");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertIsNull() {
            addCriterion("F_credit_card_cert is null");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertIsNotNull() {
            addCriterion("F_credit_card_cert is not null");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertEqualTo(String value) {
            addCriterion("F_credit_card_cert =", value, "creditCardCert");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertNotEqualTo(String value) {
            addCriterion("F_credit_card_cert <>", value, "creditCardCert");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertGreaterThan(String value) {
            addCriterion("F_credit_card_cert >", value, "creditCardCert");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertGreaterThanOrEqualTo(String value) {
            addCriterion("F_credit_card_cert >=", value, "creditCardCert");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertLessThan(String value) {
            addCriterion("F_credit_card_cert <", value, "creditCardCert");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertLessThanOrEqualTo(String value) {
            addCriterion("F_credit_card_cert <=", value, "creditCardCert");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertLike(String value) {
            addCriterion("F_credit_card_cert like", value, "creditCardCert");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertNotLike(String value) {
            addCriterion("F_credit_card_cert not like", value, "creditCardCert");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertIn(List<String> values) {
            addCriterion("F_credit_card_cert in", values, "creditCardCert");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertNotIn(List<String> values) {
            addCriterion("F_credit_card_cert not in", values, "creditCardCert");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertBetween(String value1, String value2) {
            addCriterion("F_credit_card_cert between", value1, value2, "creditCardCert");
            return (Criteria) this;
        }

        public Criteria andCreditCardCertNotBetween(String value1, String value2) {
            addCriterion("F_credit_card_cert not between", value1, value2, "creditCardCert");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIsNull() {
            addCriterion("F_merchant_id is null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIsNotNull() {
            addCriterion("F_merchant_id is not null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdEqualTo(String value) {
            addCriterion("F_merchant_id =", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotEqualTo(String value) {
            addCriterion("F_merchant_id <>", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThan(String value) {
            addCriterion("F_merchant_id >", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThanOrEqualTo(String value) {
            addCriterion("F_merchant_id >=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThan(String value) {
            addCriterion("F_merchant_id <", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThanOrEqualTo(String value) {
            addCriterion("F_merchant_id <=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLike(String value) {
            addCriterion("F_merchant_id like", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotLike(String value) {
            addCriterion("F_merchant_id not like", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIn(List<String> values) {
            addCriterion("F_merchant_id in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotIn(List<String> values) {
            addCriterion("F_merchant_id not in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdBetween(String value1, String value2) {
            addCriterion("F_merchant_id between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotBetween(String value1, String value2) {
            addCriterion("F_merchant_id not between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdIsNull() {
            addCriterion("F_out_merchant_id is null");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdIsNotNull() {
            addCriterion("F_out_merchant_id is not null");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdEqualTo(String value) {
            addCriterion("F_out_merchant_id =", value, "outMerchantId");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdNotEqualTo(String value) {
            addCriterion("F_out_merchant_id <>", value, "outMerchantId");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdGreaterThan(String value) {
            addCriterion("F_out_merchant_id >", value, "outMerchantId");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdGreaterThanOrEqualTo(String value) {
            addCriterion("F_out_merchant_id >=", value, "outMerchantId");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdLessThan(String value) {
            addCriterion("F_out_merchant_id <", value, "outMerchantId");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdLessThanOrEqualTo(String value) {
            addCriterion("F_out_merchant_id <=", value, "outMerchantId");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdLike(String value) {
            addCriterion("F_out_merchant_id like", value, "outMerchantId");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdNotLike(String value) {
            addCriterion("F_out_merchant_id not like", value, "outMerchantId");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdIn(List<String> values) {
            addCriterion("F_out_merchant_id in", values, "outMerchantId");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdNotIn(List<String> values) {
            addCriterion("F_out_merchant_id not in", values, "outMerchantId");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdBetween(String value1, String value2) {
            addCriterion("F_out_merchant_id between", value1, value2, "outMerchantId");
            return (Criteria) this;
        }

        public Criteria andOutMerchantIdNotBetween(String value1, String value2) {
            addCriterion("F_out_merchant_id not between", value1, value2, "outMerchantId");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeIsNull() {
            addCriterion("F_bank_name_code is null");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeIsNotNull() {
            addCriterion("F_bank_name_code is not null");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeEqualTo(String value) {
            addCriterion("F_bank_name_code =", value, "bankNameCode");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeNotEqualTo(String value) {
            addCriterion("F_bank_name_code <>", value, "bankNameCode");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeGreaterThan(String value) {
            addCriterion("F_bank_name_code >", value, "bankNameCode");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeGreaterThanOrEqualTo(String value) {
            addCriterion("F_bank_name_code >=", value, "bankNameCode");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeLessThan(String value) {
            addCriterion("F_bank_name_code <", value, "bankNameCode");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeLessThanOrEqualTo(String value) {
            addCriterion("F_bank_name_code <=", value, "bankNameCode");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeLike(String value) {
            addCriterion("F_bank_name_code like", value, "bankNameCode");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeNotLike(String value) {
            addCriterion("F_bank_name_code not like", value, "bankNameCode");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeIn(List<String> values) {
            addCriterion("F_bank_name_code in", values, "bankNameCode");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeNotIn(List<String> values) {
            addCriterion("F_bank_name_code not in", values, "bankNameCode");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeBetween(String value1, String value2) {
            addCriterion("F_bank_name_code between", value1, value2, "bankNameCode");
            return (Criteria) this;
        }

        public Criteria andBankNameCodeNotBetween(String value1, String value2) {
            addCriterion("F_bank_name_code not between", value1, value2, "bankNameCode");
            return (Criteria) this;
        }

        public Criteria andBankAreaIsNull() {
            addCriterion("F_bank_area is null");
            return (Criteria) this;
        }

        public Criteria andBankAreaIsNotNull() {
            addCriterion("F_bank_area is not null");
            return (Criteria) this;
        }

        public Criteria andBankAreaEqualTo(String value) {
            addCriterion("F_bank_area =", value, "bankArea");
            return (Criteria) this;
        }

        public Criteria andBankAreaNotEqualTo(String value) {
            addCriterion("F_bank_area <>", value, "bankArea");
            return (Criteria) this;
        }

        public Criteria andBankAreaGreaterThan(String value) {
            addCriterion("F_bank_area >", value, "bankArea");
            return (Criteria) this;
        }

        public Criteria andBankAreaGreaterThanOrEqualTo(String value) {
            addCriterion("F_bank_area >=", value, "bankArea");
            return (Criteria) this;
        }

        public Criteria andBankAreaLessThan(String value) {
            addCriterion("F_bank_area <", value, "bankArea");
            return (Criteria) this;
        }

        public Criteria andBankAreaLessThanOrEqualTo(String value) {
            addCriterion("F_bank_area <=", value, "bankArea");
            return (Criteria) this;
        }

        public Criteria andBankAreaLike(String value) {
            addCriterion("F_bank_area like", value, "bankArea");
            return (Criteria) this;
        }

        public Criteria andBankAreaNotLike(String value) {
            addCriterion("F_bank_area not like", value, "bankArea");
            return (Criteria) this;
        }

        public Criteria andBankAreaIn(List<String> values) {
            addCriterion("F_bank_area in", values, "bankArea");
            return (Criteria) this;
        }

        public Criteria andBankAreaNotIn(List<String> values) {
            addCriterion("F_bank_area not in", values, "bankArea");
            return (Criteria) this;
        }

        public Criteria andBankAreaBetween(String value1, String value2) {
            addCriterion("F_bank_area between", value1, value2, "bankArea");
            return (Criteria) this;
        }

        public Criteria andBankAreaNotBetween(String value1, String value2) {
            addCriterion("F_bank_area not between", value1, value2, "bankArea");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeIsNull() {
            addCriterion("F_bank_area_code is null");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeIsNotNull() {
            addCriterion("F_bank_area_code is not null");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeEqualTo(String value) {
            addCriterion("F_bank_area_code =", value, "bankAreaCode");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeNotEqualTo(String value) {
            addCriterion("F_bank_area_code <>", value, "bankAreaCode");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeGreaterThan(String value) {
            addCriterion("F_bank_area_code >", value, "bankAreaCode");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeGreaterThanOrEqualTo(String value) {
            addCriterion("F_bank_area_code >=", value, "bankAreaCode");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeLessThan(String value) {
            addCriterion("F_bank_area_code <", value, "bankAreaCode");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeLessThanOrEqualTo(String value) {
            addCriterion("F_bank_area_code <=", value, "bankAreaCode");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeLike(String value) {
            addCriterion("F_bank_area_code like", value, "bankAreaCode");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeNotLike(String value) {
            addCriterion("F_bank_area_code not like", value, "bankAreaCode");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeIn(List<String> values) {
            addCriterion("F_bank_area_code in", values, "bankAreaCode");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeNotIn(List<String> values) {
            addCriterion("F_bank_area_code not in", values, "bankAreaCode");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeBetween(String value1, String value2) {
            addCriterion("F_bank_area_code between", value1, value2, "bankAreaCode");
            return (Criteria) this;
        }

        public Criteria andBankAreaCodeNotBetween(String value1, String value2) {
            addCriterion("F_bank_area_code not between", value1, value2, "bankAreaCode");
            return (Criteria) this;
        }

        public Criteria andBankCityIsNull() {
            addCriterion("F_bank_city is null");
            return (Criteria) this;
        }

        public Criteria andBankCityIsNotNull() {
            addCriterion("F_bank_city is not null");
            return (Criteria) this;
        }

        public Criteria andBankCityEqualTo(String value) {
            addCriterion("F_bank_city =", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityNotEqualTo(String value) {
            addCriterion("F_bank_city <>", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityGreaterThan(String value) {
            addCriterion("F_bank_city >", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityGreaterThanOrEqualTo(String value) {
            addCriterion("F_bank_city >=", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityLessThan(String value) {
            addCriterion("F_bank_city <", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityLessThanOrEqualTo(String value) {
            addCriterion("F_bank_city <=", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityLike(String value) {
            addCriterion("F_bank_city like", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityNotLike(String value) {
            addCriterion("F_bank_city not like", value, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityIn(List<String> values) {
            addCriterion("F_bank_city in", values, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityNotIn(List<String> values) {
            addCriterion("F_bank_city not in", values, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityBetween(String value1, String value2) {
            addCriterion("F_bank_city between", value1, value2, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityNotBetween(String value1, String value2) {
            addCriterion("F_bank_city not between", value1, value2, "bankCity");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeIsNull() {
            addCriterion("F_bank_city_code is null");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeIsNotNull() {
            addCriterion("F_bank_city_code is not null");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeEqualTo(String value) {
            addCriterion("F_bank_city_code =", value, "bankCityCode");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeNotEqualTo(String value) {
            addCriterion("F_bank_city_code <>", value, "bankCityCode");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeGreaterThan(String value) {
            addCriterion("F_bank_city_code >", value, "bankCityCode");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeGreaterThanOrEqualTo(String value) {
            addCriterion("F_bank_city_code >=", value, "bankCityCode");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeLessThan(String value) {
            addCriterion("F_bank_city_code <", value, "bankCityCode");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeLessThanOrEqualTo(String value) {
            addCriterion("F_bank_city_code <=", value, "bankCityCode");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeLike(String value) {
            addCriterion("F_bank_city_code like", value, "bankCityCode");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeNotLike(String value) {
            addCriterion("F_bank_city_code not like", value, "bankCityCode");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeIn(List<String> values) {
            addCriterion("F_bank_city_code in", values, "bankCityCode");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeNotIn(List<String> values) {
            addCriterion("F_bank_city_code not in", values, "bankCityCode");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeBetween(String value1, String value2) {
            addCriterion("F_bank_city_code between", value1, value2, "bankCityCode");
            return (Criteria) this;
        }

        public Criteria andBankCityCodeNotBetween(String value1, String value2) {
            addCriterion("F_bank_city_code not between", value1, value2, "bankCityCode");
            return (Criteria) this;
        }

        public Criteria andCashierDeskIsNull() {
            addCriterion("F_cashier_desk is null");
            return (Criteria) this;
        }

        public Criteria andCashierDeskIsNotNull() {
            addCriterion("F_cashier_desk is not null");
            return (Criteria) this;
        }

        public Criteria andCashierDeskEqualTo(String value) {
            addCriterion("F_cashier_desk =", value, "cashierDesk");
            return (Criteria) this;
        }

        public Criteria andCashierDeskNotEqualTo(String value) {
            addCriterion("F_cashier_desk <>", value, "cashierDesk");
            return (Criteria) this;
        }

        public Criteria andCashierDeskGreaterThan(String value) {
            addCriterion("F_cashier_desk >", value, "cashierDesk");
            return (Criteria) this;
        }

        public Criteria andCashierDeskGreaterThanOrEqualTo(String value) {
            addCriterion("F_cashier_desk >=", value, "cashierDesk");
            return (Criteria) this;
        }

        public Criteria andCashierDeskLessThan(String value) {
            addCriterion("F_cashier_desk <", value, "cashierDesk");
            return (Criteria) this;
        }

        public Criteria andCashierDeskLessThanOrEqualTo(String value) {
            addCriterion("F_cashier_desk <=", value, "cashierDesk");
            return (Criteria) this;
        }

        public Criteria andCashierDeskLike(String value) {
            addCriterion("F_cashier_desk like", value, "cashierDesk");
            return (Criteria) this;
        }

        public Criteria andCashierDeskNotLike(String value) {
            addCriterion("F_cashier_desk not like", value, "cashierDesk");
            return (Criteria) this;
        }

        public Criteria andCashierDeskIn(List<String> values) {
            addCriterion("F_cashier_desk in", values, "cashierDesk");
            return (Criteria) this;
        }

        public Criteria andCashierDeskNotIn(List<String> values) {
            addCriterion("F_cashier_desk not in", values, "cashierDesk");
            return (Criteria) this;
        }

        public Criteria andCashierDeskBetween(String value1, String value2) {
            addCriterion("F_cashier_desk between", value1, value2, "cashierDesk");
            return (Criteria) this;
        }

        public Criteria andCashierDeskNotBetween(String value1, String value2) {
            addCriterion("F_cashier_desk not between", value1, value2, "cashierDesk");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveIsNull() {
            addCriterion("F_direct_sell_prove is null");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveIsNotNull() {
            addCriterion("F_direct_sell_prove is not null");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveEqualTo(String value) {
            addCriterion("F_direct_sell_prove =", value, "directSellProve");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveNotEqualTo(String value) {
            addCriterion("F_direct_sell_prove <>", value, "directSellProve");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveGreaterThan(String value) {
            addCriterion("F_direct_sell_prove >", value, "directSellProve");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveGreaterThanOrEqualTo(String value) {
            addCriterion("F_direct_sell_prove >=", value, "directSellProve");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveLessThan(String value) {
            addCriterion("F_direct_sell_prove <", value, "directSellProve");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveLessThanOrEqualTo(String value) {
            addCriterion("F_direct_sell_prove <=", value, "directSellProve");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveLike(String value) {
            addCriterion("F_direct_sell_prove like", value, "directSellProve");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveNotLike(String value) {
            addCriterion("F_direct_sell_prove not like", value, "directSellProve");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveIn(List<String> values) {
            addCriterion("F_direct_sell_prove in", values, "directSellProve");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveNotIn(List<String> values) {
            addCriterion("F_direct_sell_prove not in", values, "directSellProve");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveBetween(String value1, String value2) {
            addCriterion("F_direct_sell_prove between", value1, value2, "directSellProve");
            return (Criteria) this;
        }

        public Criteria andDirectSellProveNotBetween(String value1, String value2) {
            addCriterion("F_direct_sell_prove not between", value1, value2, "directSellProve");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveIsNull() {
            addCriterion("F_personal_tax_prove is null");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveIsNotNull() {
            addCriterion("F_personal_tax_prove is not null");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveEqualTo(String value) {
            addCriterion("F_personal_tax_prove =", value, "personalTaxProve");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveNotEqualTo(String value) {
            addCriterion("F_personal_tax_prove <>", value, "personalTaxProve");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveGreaterThan(String value) {
            addCriterion("F_personal_tax_prove >", value, "personalTaxProve");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveGreaterThanOrEqualTo(String value) {
            addCriterion("F_personal_tax_prove >=", value, "personalTaxProve");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveLessThan(String value) {
            addCriterion("F_personal_tax_prove <", value, "personalTaxProve");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveLessThanOrEqualTo(String value) {
            addCriterion("F_personal_tax_prove <=", value, "personalTaxProve");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveLike(String value) {
            addCriterion("F_personal_tax_prove like", value, "personalTaxProve");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveNotLike(String value) {
            addCriterion("F_personal_tax_prove not like", value, "personalTaxProve");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveIn(List<String> values) {
            addCriterion("F_personal_tax_prove in", values, "personalTaxProve");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveNotIn(List<String> values) {
            addCriterion("F_personal_tax_prove not in", values, "personalTaxProve");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveBetween(String value1, String value2) {
            addCriterion("F_personal_tax_prove between", value1, value2, "personalTaxProve");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveNotBetween(String value1, String value2) {
            addCriterion("F_personal_tax_prove not between", value1, value2, "personalTaxProve");
            return (Criteria) this;
        }

        public Criteria andOtherIsNull() {
            addCriterion("F_other is null");
            return (Criteria) this;
        }

        public Criteria andOtherIsNotNull() {
            addCriterion("F_other is not null");
            return (Criteria) this;
        }

        public Criteria andOtherEqualTo(String value) {
            addCriterion("F_other =", value, "other");
            return (Criteria) this;
        }

        public Criteria andOtherNotEqualTo(String value) {
            addCriterion("F_other <>", value, "other");
            return (Criteria) this;
        }

        public Criteria andOtherGreaterThan(String value) {
            addCriterion("F_other >", value, "other");
            return (Criteria) this;
        }

        public Criteria andOtherGreaterThanOrEqualTo(String value) {
            addCriterion("F_other >=", value, "other");
            return (Criteria) this;
        }

        public Criteria andOtherLessThan(String value) {
            addCriterion("F_other <", value, "other");
            return (Criteria) this;
        }

        public Criteria andOtherLessThanOrEqualTo(String value) {
            addCriterion("F_other <=", value, "other");
            return (Criteria) this;
        }

        public Criteria andOtherLike(String value) {
            addCriterion("F_other like", value, "other");
            return (Criteria) this;
        }

        public Criteria andOtherNotLike(String value) {
            addCriterion("F_other not like", value, "other");
            return (Criteria) this;
        }

        public Criteria andOtherIn(List<String> values) {
            addCriterion("F_other in", values, "other");
            return (Criteria) this;
        }

        public Criteria andOtherNotIn(List<String> values) {
            addCriterion("F_other not in", values, "other");
            return (Criteria) this;
        }

        public Criteria andOtherBetween(String value1, String value2) {
            addCriterion("F_other between", value1, value2, "other");
            return (Criteria) this;
        }

        public Criteria andOtherNotBetween(String value1, String value2) {
            addCriterion("F_other not between", value1, value2, "other");
            return (Criteria) this;
        }

        public Criteria andLastUdpateTimeIsNull() {
            addCriterion("F_last_udpate_time is null");
            return (Criteria) this;
        }

        public Criteria andLastUdpateTimeIsNotNull() {
            addCriterion("F_last_udpate_time is not null");
            return (Criteria) this;
        }

        public Criteria andLastUdpateTimeEqualTo(Date value) {
            addCriterion("F_last_udpate_time =", value, "lastUdpateTime");
            return (Criteria) this;
        }

        public Criteria andLastUdpateTimeNotEqualTo(Date value) {
            addCriterion("F_last_udpate_time <>", value, "lastUdpateTime");
            return (Criteria) this;
        }

        public Criteria andLastUdpateTimeGreaterThan(Date value) {
            addCriterion("F_last_udpate_time >", value, "lastUdpateTime");
            return (Criteria) this;
        }

        public Criteria andLastUdpateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("F_last_udpate_time >=", value, "lastUdpateTime");
            return (Criteria) this;
        }

        public Criteria andLastUdpateTimeLessThan(Date value) {
            addCriterion("F_last_udpate_time <", value, "lastUdpateTime");
            return (Criteria) this;
        }

        public Criteria andLastUdpateTimeLessThanOrEqualTo(Date value) {
            addCriterion("F_last_udpate_time <=", value, "lastUdpateTime");
            return (Criteria) this;
        }

        public Criteria andLastUdpateTimeIn(List<Date> values) {
            addCriterion("F_last_udpate_time in", values, "lastUdpateTime");
            return (Criteria) this;
        }

        public Criteria andLastUdpateTimeNotIn(List<Date> values) {
            addCriterion("F_last_udpate_time not in", values, "lastUdpateTime");
            return (Criteria) this;
        }

        public Criteria andLastUdpateTimeBetween(Date value1, Date value2) {
            addCriterion("F_last_udpate_time between", value1, value2, "lastUdpateTime");
            return (Criteria) this;
        }

        public Criteria andLastUdpateTimeNotBetween(Date value1, Date value2) {
            addCriterion("F_last_udpate_time not between", value1, value2, "lastUdpateTime");
            return (Criteria) this;
        }

        public Criteria andTopAgentPassTimeIsNull() {
            addCriterion("F_top_agent_pass_time is null");
            return (Criteria) this;
        }

        public Criteria andTopAgentPassTimeIsNotNull() {
            addCriterion("F_top_agent_pass_time is not null");
            return (Criteria) this;
        }

        public Criteria andTopAgentPassTimeEqualTo(Date value) {
            addCriterion("F_top_agent_pass_time =", value, "topAgentPassTime");
            return (Criteria) this;
        }

        public Criteria andTopAgentPassTimeNotEqualTo(Date value) {
            addCriterion("F_top_agent_pass_time <>", value, "topAgentPassTime");
            return (Criteria) this;
        }

        public Criteria andTopAgentPassTimeGreaterThan(Date value) {
            addCriterion("F_top_agent_pass_time >", value, "topAgentPassTime");
            return (Criteria) this;
        }

        public Criteria andTopAgentPassTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("F_top_agent_pass_time >=", value, "topAgentPassTime");
            return (Criteria) this;
        }

        public Criteria andTopAgentPassTimeLessThan(Date value) {
            addCriterion("F_top_agent_pass_time <", value, "topAgentPassTime");
            return (Criteria) this;
        }

        public Criteria andTopAgentPassTimeLessThanOrEqualTo(Date value) {
            addCriterion("F_top_agent_pass_time <=", value, "topAgentPassTime");
            return (Criteria) this;
        }

        public Criteria andTopAgentPassTimeIn(List<Date> values) {
            addCriterion("F_top_agent_pass_time in", values, "topAgentPassTime");
            return (Criteria) this;
        }

        public Criteria andTopAgentPassTimeNotIn(List<Date> values) {
            addCriterion("F_top_agent_pass_time not in", values, "topAgentPassTime");
            return (Criteria) this;
        }

        public Criteria andTopAgentPassTimeBetween(Date value1, Date value2) {
            addCriterion("F_top_agent_pass_time between", value1, value2, "topAgentPassTime");
            return (Criteria) this;
        }

        public Criteria andTopAgentPassTimeNotBetween(Date value1, Date value2) {
            addCriterion("F_top_agent_pass_time not between", value1, value2, "topAgentPassTime");
            return (Criteria) this;
        }

        public Criteria andBankAccountTypeIsNull() {
            addCriterion("F_bank_account_type is null");
            return (Criteria) this;
        }

        public Criteria andBankAccountTypeIsNotNull() {
            addCriterion("F_bank_account_type is not null");
            return (Criteria) this;
        }

        public Criteria andBankAccountTypeEqualTo(Integer value) {
            addCriterion("F_bank_account_type =", value, "bankAccountType");
            return (Criteria) this;
        }

        public Criteria andBankAccountTypeNotEqualTo(Integer value) {
            addCriterion("F_bank_account_type <>", value, "bankAccountType");
            return (Criteria) this;
        }

        public Criteria andBankAccountTypeGreaterThan(Integer value) {
            addCriterion("F_bank_account_type >", value, "bankAccountType");
            return (Criteria) this;
        }

        public Criteria andBankAccountTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_bank_account_type >=", value, "bankAccountType");
            return (Criteria) this;
        }

        public Criteria andBankAccountTypeLessThan(Integer value) {
            addCriterion("F_bank_account_type <", value, "bankAccountType");
            return (Criteria) this;
        }

        public Criteria andBankAccountTypeLessThanOrEqualTo(Integer value) {
            addCriterion("F_bank_account_type <=", value, "bankAccountType");
            return (Criteria) this;
        }

        public Criteria andBankAccountTypeIn(List<Integer> values) {
            addCriterion("F_bank_account_type in", values, "bankAccountType");
            return (Criteria) this;
        }

        public Criteria andBankAccountTypeNotIn(List<Integer> values) {
            addCriterion("F_bank_account_type not in", values, "bankAccountType");
            return (Criteria) this;
        }

        public Criteria andBankAccountTypeBetween(Integer value1, Integer value2) {
            addCriterion("F_bank_account_type between", value1, value2, "bankAccountType");
            return (Criteria) this;
        }

        public Criteria andBankAccountTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("F_bank_account_type not between", value1, value2, "bankAccountType");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNull() {
            addCriterion("F_contract_number is null");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNotNull() {
            addCriterion("F_contract_number is not null");
            return (Criteria) this;
        }

        public Criteria andContractNumberEqualTo(String value) {
            addCriterion("F_contract_number =", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotEqualTo(String value) {
            addCriterion("F_contract_number <>", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThan(String value) {
            addCriterion("F_contract_number >", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThanOrEqualTo(String value) {
            addCriterion("F_contract_number >=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThan(String value) {
            addCriterion("F_contract_number <", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThanOrEqualTo(String value) {
            addCriterion("F_contract_number <=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLike(String value) {
            addCriterion("F_contract_number like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotLike(String value) {
            addCriterion("F_contract_number not like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberIn(List<String> values) {
            addCriterion("F_contract_number in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotIn(List<String> values) {
            addCriterion("F_contract_number not in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberBetween(String value1, String value2) {
            addCriterion("F_contract_number between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotBetween(String value1, String value2) {
            addCriterion("F_contract_number not between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andInstallmentsDownIsNull() {
            addCriterion("F_installments_down is null");
            return (Criteria) this;
        }

        public Criteria andInstallmentsDownIsNotNull() {
            addCriterion("F_installments_down is not null");
            return (Criteria) this;
        }

        public Criteria andInstallmentsDownEqualTo(Integer value) {
            addCriterion("F_installments_down =", value, "installmentsDown");
            return (Criteria) this;
        }

        public Criteria andInstallmentsDownNotEqualTo(Integer value) {
            addCriterion("F_installments_down <>", value, "installmentsDown");
            return (Criteria) this;
        }

        public Criteria andInstallmentsDownGreaterThan(Integer value) {
            addCriterion("F_installments_down >", value, "installmentsDown");
            return (Criteria) this;
        }

        public Criteria andInstallmentsDownGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_installments_down >=", value, "installmentsDown");
            return (Criteria) this;
        }

        public Criteria andInstallmentsDownLessThan(Integer value) {
            addCriterion("F_installments_down <", value, "installmentsDown");
            return (Criteria) this;
        }

        public Criteria andInstallmentsDownLessThanOrEqualTo(Integer value) {
            addCriterion("F_installments_down <=", value, "installmentsDown");
            return (Criteria) this;
        }

        public Criteria andInstallmentsDownIn(List<Integer> values) {
            addCriterion("F_installments_down in", values, "installmentsDown");
            return (Criteria) this;
        }

        public Criteria andInstallmentsDownNotIn(List<Integer> values) {
            addCriterion("F_installments_down not in", values, "installmentsDown");
            return (Criteria) this;
        }

        public Criteria andInstallmentsDownBetween(Integer value1, Integer value2) {
            addCriterion("F_installments_down between", value1, value2, "installmentsDown");
            return (Criteria) this;
        }

        public Criteria andInstallmentsDownNotBetween(Integer value1, Integer value2) {
            addCriterion("F_installments_down not between", value1, value2, "installmentsDown");
            return (Criteria) this;
        }

        public Criteria andInstallmentsPeriodsIsNull() {
            addCriterion("F_installments_periods is null");
            return (Criteria) this;
        }

        public Criteria andInstallmentsPeriodsIsNotNull() {
            addCriterion("F_installments_periods is not null");
            return (Criteria) this;
        }

        public Criteria andInstallmentsPeriodsEqualTo(Integer value) {
            addCriterion("F_installments_periods =", value, "installmentsPeriods");
            return (Criteria) this;
        }

        public Criteria andInstallmentsPeriodsNotEqualTo(Integer value) {
            addCriterion("F_installments_periods <>", value, "installmentsPeriods");
            return (Criteria) this;
        }

        public Criteria andInstallmentsPeriodsGreaterThan(Integer value) {
            addCriterion("F_installments_periods >", value, "installmentsPeriods");
            return (Criteria) this;
        }

        public Criteria andInstallmentsPeriodsGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_installments_periods >=", value, "installmentsPeriods");
            return (Criteria) this;
        }

        public Criteria andInstallmentsPeriodsLessThan(Integer value) {
            addCriterion("F_installments_periods <", value, "installmentsPeriods");
            return (Criteria) this;
        }

        public Criteria andInstallmentsPeriodsLessThanOrEqualTo(Integer value) {
            addCriterion("F_installments_periods <=", value, "installmentsPeriods");
            return (Criteria) this;
        }

        public Criteria andInstallmentsPeriodsIn(List<Integer> values) {
            addCriterion("F_installments_periods in", values, "installmentsPeriods");
            return (Criteria) this;
        }

        public Criteria andInstallmentsPeriodsNotIn(List<Integer> values) {
            addCriterion("F_installments_periods not in", values, "installmentsPeriods");
            return (Criteria) this;
        }

        public Criteria andInstallmentsPeriodsBetween(Integer value1, Integer value2) {
            addCriterion("F_installments_periods between", value1, value2, "installmentsPeriods");
            return (Criteria) this;
        }

        public Criteria andInstallmentsPeriodsNotBetween(Integer value1, Integer value2) {
            addCriterion("F_installments_periods not between", value1, value2, "installmentsPeriods");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAmountIsNull() {
            addCriterion("F_installments_amount is null");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAmountIsNotNull() {
            addCriterion("F_installments_amount is not null");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAmountEqualTo(Integer value) {
            addCriterion("F_installments_amount =", value, "installmentsAmount");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAmountNotEqualTo(Integer value) {
            addCriterion("F_installments_amount <>", value, "installmentsAmount");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAmountGreaterThan(Integer value) {
            addCriterion("F_installments_amount >", value, "installmentsAmount");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAmountGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_installments_amount >=", value, "installmentsAmount");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAmountLessThan(Integer value) {
            addCriterion("F_installments_amount <", value, "installmentsAmount");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAmountLessThanOrEqualTo(Integer value) {
            addCriterion("F_installments_amount <=", value, "installmentsAmount");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAmountIn(List<Integer> values) {
            addCriterion("F_installments_amount in", values, "installmentsAmount");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAmountNotIn(List<Integer> values) {
            addCriterion("F_installments_amount not in", values, "installmentsAmount");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAmountBetween(Integer value1, Integer value2) {
            addCriterion("F_installments_amount between", value1, value2, "installmentsAmount");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAmountNotBetween(Integer value1, Integer value2) {
            addCriterion("F_installments_amount not between", value1, value2, "installmentsAmount");
            return (Criteria) this;
        }

        public Criteria andInstallmentsFlagIsNull() {
            addCriterion("F_installments_flag is null");
            return (Criteria) this;
        }

        public Criteria andInstallmentsFlagIsNotNull() {
            addCriterion("F_installments_flag is not null");
            return (Criteria) this;
        }

        public Criteria andInstallmentsFlagEqualTo(Integer value) {
            addCriterion("F_installments_flag =", value, "installmentsFlag");
            return (Criteria) this;
        }

        public Criteria andInstallmentsFlagNotEqualTo(Integer value) {
            addCriterion("F_installments_flag <>", value, "installmentsFlag");
            return (Criteria) this;
        }

        public Criteria andInstallmentsFlagGreaterThan(Integer value) {
            addCriterion("F_installments_flag >", value, "installmentsFlag");
            return (Criteria) this;
        }

        public Criteria andInstallmentsFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_installments_flag >=", value, "installmentsFlag");
            return (Criteria) this;
        }

        public Criteria andInstallmentsFlagLessThan(Integer value) {
            addCriterion("F_installments_flag <", value, "installmentsFlag");
            return (Criteria) this;
        }

        public Criteria andInstallmentsFlagLessThanOrEqualTo(Integer value) {
            addCriterion("F_installments_flag <=", value, "installmentsFlag");
            return (Criteria) this;
        }

        public Criteria andInstallmentsFlagIn(List<Integer> values) {
            addCriterion("F_installments_flag in", values, "installmentsFlag");
            return (Criteria) this;
        }

        public Criteria andInstallmentsFlagNotIn(List<Integer> values) {
            addCriterion("F_installments_flag not in", values, "installmentsFlag");
            return (Criteria) this;
        }

        public Criteria andInstallmentsFlagBetween(Integer value1, Integer value2) {
            addCriterion("F_installments_flag between", value1, value2, "installmentsFlag");
            return (Criteria) this;
        }

        public Criteria andInstallmentsFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("F_installments_flag not between", value1, value2, "installmentsFlag");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementIsNull() {
            addCriterion("F_installments_agreement is null");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementIsNotNull() {
            addCriterion("F_installments_agreement is not null");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementEqualTo(String value) {
            addCriterion("F_installments_agreement =", value, "installmentsAgreement");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementNotEqualTo(String value) {
            addCriterion("F_installments_agreement <>", value, "installmentsAgreement");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementGreaterThan(String value) {
            addCriterion("F_installments_agreement >", value, "installmentsAgreement");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementGreaterThanOrEqualTo(String value) {
            addCriterion("F_installments_agreement >=", value, "installmentsAgreement");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementLessThan(String value) {
            addCriterion("F_installments_agreement <", value, "installmentsAgreement");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementLessThanOrEqualTo(String value) {
            addCriterion("F_installments_agreement <=", value, "installmentsAgreement");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementLike(String value) {
            addCriterion("F_installments_agreement like", value, "installmentsAgreement");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementNotLike(String value) {
            addCriterion("F_installments_agreement not like", value, "installmentsAgreement");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementIn(List<String> values) {
            addCriterion("F_installments_agreement in", values, "installmentsAgreement");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementNotIn(List<String> values) {
            addCriterion("F_installments_agreement not in", values, "installmentsAgreement");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementBetween(String value1, String value2) {
            addCriterion("F_installments_agreement between", value1, value2, "installmentsAgreement");
            return (Criteria) this;
        }

        public Criteria andInstallmentsAgreementNotBetween(String value1, String value2) {
            addCriterion("F_installments_agreement not between", value1, value2, "installmentsAgreement");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeIsNull() {
            addCriterion("F_organization_code is null");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeIsNotNull() {
            addCriterion("F_organization_code is not null");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeEqualTo(String value) {
            addCriterion("F_organization_code =", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeNotEqualTo(String value) {
            addCriterion("F_organization_code <>", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeGreaterThan(String value) {
            addCriterion("F_organization_code >", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeGreaterThanOrEqualTo(String value) {
            addCriterion("F_organization_code >=", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeLessThan(String value) {
            addCriterion("F_organization_code <", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeLessThanOrEqualTo(String value) {
            addCriterion("F_organization_code <=", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeLike(String value) {
            addCriterion("F_organization_code like", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeNotLike(String value) {
            addCriterion("F_organization_code not like", value, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeIn(List<String> values) {
            addCriterion("F_organization_code in", values, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeNotIn(List<String> values) {
            addCriterion("F_organization_code not in", values, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeBetween(String value1, String value2) {
            addCriterion("F_organization_code between", value1, value2, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeNotBetween(String value1, String value2) {
            addCriterion("F_organization_code not between", value1, value2, "organizationCode");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrIsNull() {
            addCriterion("F_register_ipaddr is null");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrIsNotNull() {
            addCriterion("F_register_ipaddr is not null");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrEqualTo(String value) {
            addCriterion("F_register_ipaddr =", value, "registerIpaddr");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrNotEqualTo(String value) {
            addCriterion("F_register_ipaddr <>", value, "registerIpaddr");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrGreaterThan(String value) {
            addCriterion("F_register_ipaddr >", value, "registerIpaddr");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrGreaterThanOrEqualTo(String value) {
            addCriterion("F_register_ipaddr >=", value, "registerIpaddr");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrLessThan(String value) {
            addCriterion("F_register_ipaddr <", value, "registerIpaddr");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrLessThanOrEqualTo(String value) {
            addCriterion("F_register_ipaddr <=", value, "registerIpaddr");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrLike(String value) {
            addCriterion("F_register_ipaddr like", value, "registerIpaddr");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrNotLike(String value) {
            addCriterion("F_register_ipaddr not like", value, "registerIpaddr");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrIn(List<String> values) {
            addCriterion("F_register_ipaddr in", values, "registerIpaddr");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrNotIn(List<String> values) {
            addCriterion("F_register_ipaddr not in", values, "registerIpaddr");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrBetween(String value1, String value2) {
            addCriterion("F_register_ipaddr between", value1, value2, "registerIpaddr");
            return (Criteria) this;
        }

        public Criteria andRegisterIpaddrNotBetween(String value1, String value2) {
            addCriterion("F_register_ipaddr not between", value1, value2, "registerIpaddr");
            return (Criteria) this;
        }

        public Criteria andCityNoIsNull() {
            addCriterion("F_city_no is null");
            return (Criteria) this;
        }

        public Criteria andCityNoIsNotNull() {
            addCriterion("F_city_no is not null");
            return (Criteria) this;
        }

        public Criteria andCityNoEqualTo(Integer value) {
            addCriterion("F_city_no =", value, "cityNo");
            return (Criteria) this;
        }

        public Criteria andCityNoNotEqualTo(Integer value) {
            addCriterion("F_city_no <>", value, "cityNo");
            return (Criteria) this;
        }

        public Criteria andCityNoGreaterThan(Integer value) {
            addCriterion("F_city_no >", value, "cityNo");
            return (Criteria) this;
        }

        public Criteria andCityNoGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_city_no >=", value, "cityNo");
            return (Criteria) this;
        }

        public Criteria andCityNoLessThan(Integer value) {
            addCriterion("F_city_no <", value, "cityNo");
            return (Criteria) this;
        }

        public Criteria andCityNoLessThanOrEqualTo(Integer value) {
            addCriterion("F_city_no <=", value, "cityNo");
            return (Criteria) this;
        }

        public Criteria andCityNoIn(List<Integer> values) {
            addCriterion("F_city_no in", values, "cityNo");
            return (Criteria) this;
        }

        public Criteria andCityNoNotIn(List<Integer> values) {
            addCriterion("F_city_no not in", values, "cityNo");
            return (Criteria) this;
        }

        public Criteria andCityNoBetween(Integer value1, Integer value2) {
            addCriterion("F_city_no between", value1, value2, "cityNo");
            return (Criteria) this;
        }

        public Criteria andCityNoNotBetween(Integer value1, Integer value2) {
            addCriterion("F_city_no not between", value1, value2, "cityNo");
            return (Criteria) this;
        }

        public Criteria andXIsNull() {
            addCriterion("F_x is null");
            return (Criteria) this;
        }

        public Criteria andXIsNotNull() {
            addCriterion("F_x is not null");
            return (Criteria) this;
        }

        public Criteria andXEqualTo(String value) {
            addCriterion("F_x =", value, "x");
            return (Criteria) this;
        }

        public Criteria andXNotEqualTo(String value) {
            addCriterion("F_x <>", value, "x");
            return (Criteria) this;
        }

        public Criteria andXGreaterThan(String value) {
            addCriterion("F_x >", value, "x");
            return (Criteria) this;
        }

        public Criteria andXGreaterThanOrEqualTo(String value) {
            addCriterion("F_x >=", value, "x");
            return (Criteria) this;
        }

        public Criteria andXLessThan(String value) {
            addCriterion("F_x <", value, "x");
            return (Criteria) this;
        }

        public Criteria andXLessThanOrEqualTo(String value) {
            addCriterion("F_x <=", value, "x");
            return (Criteria) this;
        }

        public Criteria andXLike(String value) {
            addCriterion("F_x like", value, "x");
            return (Criteria) this;
        }

        public Criteria andXNotLike(String value) {
            addCriterion("F_x not like", value, "x");
            return (Criteria) this;
        }

        public Criteria andXIn(List<String> values) {
            addCriterion("F_x in", values, "x");
            return (Criteria) this;
        }

        public Criteria andXNotIn(List<String> values) {
            addCriterion("F_x not in", values, "x");
            return (Criteria) this;
        }

        public Criteria andXBetween(String value1, String value2) {
            addCriterion("F_x between", value1, value2, "x");
            return (Criteria) this;
        }

        public Criteria andXNotBetween(String value1, String value2) {
            addCriterion("F_x not between", value1, value2, "x");
            return (Criteria) this;
        }

        public Criteria andYIsNull() {
            addCriterion("F_y is null");
            return (Criteria) this;
        }

        public Criteria andYIsNotNull() {
            addCriterion("F_y is not null");
            return (Criteria) this;
        }

        public Criteria andYEqualTo(String value) {
            addCriterion("F_y =", value, "y");
            return (Criteria) this;
        }

        public Criteria andYNotEqualTo(String value) {
            addCriterion("F_y <>", value, "y");
            return (Criteria) this;
        }

        public Criteria andYGreaterThan(String value) {
            addCriterion("F_y >", value, "y");
            return (Criteria) this;
        }

        public Criteria andYGreaterThanOrEqualTo(String value) {
            addCriterion("F_y >=", value, "y");
            return (Criteria) this;
        }

        public Criteria andYLessThan(String value) {
            addCriterion("F_y <", value, "y");
            return (Criteria) this;
        }

        public Criteria andYLessThanOrEqualTo(String value) {
            addCriterion("F_y <=", value, "y");
            return (Criteria) this;
        }

        public Criteria andYLike(String value) {
            addCriterion("F_y like", value, "y");
            return (Criteria) this;
        }

        public Criteria andYNotLike(String value) {
            addCriterion("F_y not like", value, "y");
            return (Criteria) this;
        }

        public Criteria andYIn(List<String> values) {
            addCriterion("F_y in", values, "y");
            return (Criteria) this;
        }

        public Criteria andYNotIn(List<String> values) {
            addCriterion("F_y not in", values, "y");
            return (Criteria) this;
        }

        public Criteria andYBetween(String value1, String value2) {
            addCriterion("F_y between", value1, value2, "y");
            return (Criteria) this;
        }

        public Criteria andYNotBetween(String value1, String value2) {
            addCriterion("F_y not between", value1, value2, "y");
            return (Criteria) this;
        }

        public Criteria andLicenseIsNull() {
            addCriterion("F_license is null");
            return (Criteria) this;
        }

        public Criteria andLicenseIsNotNull() {
            addCriterion("F_license is not null");
            return (Criteria) this;
        }

        public Criteria andLicenseEqualTo(String value) {
            addCriterion("F_license =", value, "license");
            return (Criteria) this;
        }

        public Criteria andLicenseNotEqualTo(String value) {
            addCriterion("F_license <>", value, "license");
            return (Criteria) this;
        }

        public Criteria andLicenseGreaterThan(String value) {
            addCriterion("F_license >", value, "license");
            return (Criteria) this;
        }

        public Criteria andLicenseGreaterThanOrEqualTo(String value) {
            addCriterion("F_license >=", value, "license");
            return (Criteria) this;
        }

        public Criteria andLicenseLessThan(String value) {
            addCriterion("F_license <", value, "license");
            return (Criteria) this;
        }

        public Criteria andLicenseLessThanOrEqualTo(String value) {
            addCriterion("F_license <=", value, "license");
            return (Criteria) this;
        }

        public Criteria andLicenseLike(String value) {
            addCriterion("F_license like", value, "license");
            return (Criteria) this;
        }

        public Criteria andLicenseNotLike(String value) {
            addCriterion("F_license not like", value, "license");
            return (Criteria) this;
        }

        public Criteria andLicenseIn(List<String> values) {
            addCriterion("F_license in", values, "license");
            return (Criteria) this;
        }

        public Criteria andLicenseNotIn(List<String> values) {
            addCriterion("F_license not in", values, "license");
            return (Criteria) this;
        }

        public Criteria andLicenseBetween(String value1, String value2) {
            addCriterion("F_license between", value1, value2, "license");
            return (Criteria) this;
        }

        public Criteria andLicenseNotBetween(String value1, String value2) {
            addCriterion("F_license not between", value1, value2, "license");
            return (Criteria) this;
        }

        public Criteria andLicenseStartIsNull() {
            addCriterion("F_license_start is null");
            return (Criteria) this;
        }

        public Criteria andLicenseStartIsNotNull() {
            addCriterion("F_license_start is not null");
            return (Criteria) this;
        }

        public Criteria andLicenseStartEqualTo(String value) {
            addCriterion("F_license_start =", value, "licenseStart");
            return (Criteria) this;
        }

        public Criteria andLicenseStartNotEqualTo(String value) {
            addCriterion("F_license_start <>", value, "licenseStart");
            return (Criteria) this;
        }

        public Criteria andLicenseStartGreaterThan(String value) {
            addCriterion("F_license_start >", value, "licenseStart");
            return (Criteria) this;
        }

        public Criteria andLicenseStartGreaterThanOrEqualTo(String value) {
            addCriterion("F_license_start >=", value, "licenseStart");
            return (Criteria) this;
        }

        public Criteria andLicenseStartLessThan(String value) {
            addCriterion("F_license_start <", value, "licenseStart");
            return (Criteria) this;
        }

        public Criteria andLicenseStartLessThanOrEqualTo(String value) {
            addCriterion("F_license_start <=", value, "licenseStart");
            return (Criteria) this;
        }

        public Criteria andLicenseStartLike(String value) {
            addCriterion("F_license_start like", value, "licenseStart");
            return (Criteria) this;
        }

        public Criteria andLicenseStartNotLike(String value) {
            addCriterion("F_license_start not like", value, "licenseStart");
            return (Criteria) this;
        }

        public Criteria andLicenseStartIn(List<String> values) {
            addCriterion("F_license_start in", values, "licenseStart");
            return (Criteria) this;
        }

        public Criteria andLicenseStartNotIn(List<String> values) {
            addCriterion("F_license_start not in", values, "licenseStart");
            return (Criteria) this;
        }

        public Criteria andLicenseStartBetween(String value1, String value2) {
            addCriterion("F_license_start between", value1, value2, "licenseStart");
            return (Criteria) this;
        }

        public Criteria andLicenseStartNotBetween(String value1, String value2) {
            addCriterion("F_license_start not between", value1, value2, "licenseStart");
            return (Criteria) this;
        }

        public Criteria andLicenseEndIsNull() {
            addCriterion("F_license_end is null");
            return (Criteria) this;
        }

        public Criteria andLicenseEndIsNotNull() {
            addCriterion("F_license_end is not null");
            return (Criteria) this;
        }

        public Criteria andLicenseEndEqualTo(String value) {
            addCriterion("F_license_end =", value, "licenseEnd");
            return (Criteria) this;
        }

        public Criteria andLicenseEndNotEqualTo(String value) {
            addCriterion("F_license_end <>", value, "licenseEnd");
            return (Criteria) this;
        }

        public Criteria andLicenseEndGreaterThan(String value) {
            addCriterion("F_license_end >", value, "licenseEnd");
            return (Criteria) this;
        }

        public Criteria andLicenseEndGreaterThanOrEqualTo(String value) {
            addCriterion("F_license_end >=", value, "licenseEnd");
            return (Criteria) this;
        }

        public Criteria andLicenseEndLessThan(String value) {
            addCriterion("F_license_end <", value, "licenseEnd");
            return (Criteria) this;
        }

        public Criteria andLicenseEndLessThanOrEqualTo(String value) {
            addCriterion("F_license_end <=", value, "licenseEnd");
            return (Criteria) this;
        }

        public Criteria andLicenseEndLike(String value) {
            addCriterion("F_license_end like", value, "licenseEnd");
            return (Criteria) this;
        }

        public Criteria andLicenseEndNotLike(String value) {
            addCriterion("F_license_end not like", value, "licenseEnd");
            return (Criteria) this;
        }

        public Criteria andLicenseEndIn(List<String> values) {
            addCriterion("F_license_end in", values, "licenseEnd");
            return (Criteria) this;
        }

        public Criteria andLicenseEndNotIn(List<String> values) {
            addCriterion("F_license_end not in", values, "licenseEnd");
            return (Criteria) this;
        }

        public Criteria andLicenseEndBetween(String value1, String value2) {
            addCriterion("F_license_end between", value1, value2, "licenseEnd");
            return (Criteria) this;
        }

        public Criteria andLicenseEndNotBetween(String value1, String value2) {
            addCriterion("F_license_end not between", value1, value2, "licenseEnd");
            return (Criteria) this;
        }

        public Criteria andTradeParentIsNull() {
            addCriterion("F_trade_parent is null");
            return (Criteria) this;
        }

        public Criteria andTradeParentIsNotNull() {
            addCriterion("F_trade_parent is not null");
            return (Criteria) this;
        }

        public Criteria andTradeParentEqualTo(String value) {
            addCriterion("F_trade_parent =", value, "tradeParent");
            return (Criteria) this;
        }

        public Criteria andTradeParentNotEqualTo(String value) {
            addCriterion("F_trade_parent <>", value, "tradeParent");
            return (Criteria) this;
        }

        public Criteria andTradeParentGreaterThan(String value) {
            addCriterion("F_trade_parent >", value, "tradeParent");
            return (Criteria) this;
        }

        public Criteria andTradeParentGreaterThanOrEqualTo(String value) {
            addCriterion("F_trade_parent >=", value, "tradeParent");
            return (Criteria) this;
        }

        public Criteria andTradeParentLessThan(String value) {
            addCriterion("F_trade_parent <", value, "tradeParent");
            return (Criteria) this;
        }

        public Criteria andTradeParentLessThanOrEqualTo(String value) {
            addCriterion("F_trade_parent <=", value, "tradeParent");
            return (Criteria) this;
        }

        public Criteria andTradeParentLike(String value) {
            addCriterion("F_trade_parent like", value, "tradeParent");
            return (Criteria) this;
        }

        public Criteria andTradeParentNotLike(String value) {
            addCriterion("F_trade_parent not like", value, "tradeParent");
            return (Criteria) this;
        }

        public Criteria andTradeParentIn(List<String> values) {
            addCriterion("F_trade_parent in", values, "tradeParent");
            return (Criteria) this;
        }

        public Criteria andTradeParentNotIn(List<String> values) {
            addCriterion("F_trade_parent not in", values, "tradeParent");
            return (Criteria) this;
        }

        public Criteria andTradeParentBetween(String value1, String value2) {
            addCriterion("F_trade_parent between", value1, value2, "tradeParent");
            return (Criteria) this;
        }

        public Criteria andTradeParentNotBetween(String value1, String value2) {
            addCriterion("F_trade_parent not between", value1, value2, "tradeParent");
            return (Criteria) this;
        }

        public Criteria andIsdelIsNull() {
            addCriterion("F_isdel is null");
            return (Criteria) this;
        }

        public Criteria andIsdelIsNotNull() {
            addCriterion("F_isdel is not null");
            return (Criteria) this;
        }

        public Criteria andIsdelEqualTo(Integer value) {
            addCriterion("F_isdel =", value, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelNotEqualTo(Integer value) {
            addCriterion("F_isdel <>", value, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelGreaterThan(Integer value) {
            addCriterion("F_isdel >", value, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_isdel >=", value, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelLessThan(Integer value) {
            addCriterion("F_isdel <", value, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelLessThanOrEqualTo(Integer value) {
            addCriterion("F_isdel <=", value, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelIn(List<Integer> values) {
            addCriterion("F_isdel in", values, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelNotIn(List<Integer> values) {
            addCriterion("F_isdel not in", values, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelBetween(Integer value1, Integer value2) {
            addCriterion("F_isdel between", value1, value2, "isdel");
            return (Criteria) this;
        }

        public Criteria andIsdelNotBetween(Integer value1, Integer value2) {
            addCriterion("F_isdel not between", value1, value2, "isdel");
            return (Criteria) this;
        }

        public Criteria andBalanceIsNull() {
            addCriterion("F_balance is null");
            return (Criteria) this;
        }

        public Criteria andBalanceIsNotNull() {
            addCriterion("F_balance is not null");
            return (Criteria) this;
        }

        public Criteria andBalanceEqualTo(Integer value) {
            addCriterion("F_balance =", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceNotEqualTo(Integer value) {
            addCriterion("F_balance <>", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceGreaterThan(Integer value) {
            addCriterion("F_balance >", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_balance >=", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceLessThan(Integer value) {
            addCriterion("F_balance <", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceLessThanOrEqualTo(Integer value) {
            addCriterion("F_balance <=", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceIn(List<Integer> values) {
            addCriterion("F_balance in", values, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceNotIn(List<Integer> values) {
            addCriterion("F_balance not in", values, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceBetween(Integer value1, Integer value2) {
            addCriterion("F_balance between", value1, value2, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceNotBetween(Integer value1, Integer value2) {
            addCriterion("F_balance not between", value1, value2, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceCapIsNull() {
            addCriterion("F_balance_cap is null");
            return (Criteria) this;
        }

        public Criteria andBalanceCapIsNotNull() {
            addCriterion("F_balance_cap is not null");
            return (Criteria) this;
        }

        public Criteria andBalanceCapEqualTo(Integer value) {
            addCriterion("F_balance_cap =", value, "balanceCap");
            return (Criteria) this;
        }

        public Criteria andBalanceCapNotEqualTo(Integer value) {
            addCriterion("F_balance_cap <>", value, "balanceCap");
            return (Criteria) this;
        }

        public Criteria andBalanceCapGreaterThan(Integer value) {
            addCriterion("F_balance_cap >", value, "balanceCap");
            return (Criteria) this;
        }

        public Criteria andBalanceCapGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_balance_cap >=", value, "balanceCap");
            return (Criteria) this;
        }

        public Criteria andBalanceCapLessThan(Integer value) {
            addCriterion("F_balance_cap <", value, "balanceCap");
            return (Criteria) this;
        }

        public Criteria andBalanceCapLessThanOrEqualTo(Integer value) {
            addCriterion("F_balance_cap <=", value, "balanceCap");
            return (Criteria) this;
        }

        public Criteria andBalanceCapIn(List<Integer> values) {
            addCriterion("F_balance_cap in", values, "balanceCap");
            return (Criteria) this;
        }

        public Criteria andBalanceCapNotIn(List<Integer> values) {
            addCriterion("F_balance_cap not in", values, "balanceCap");
            return (Criteria) this;
        }

        public Criteria andBalanceCapBetween(Integer value1, Integer value2) {
            addCriterion("F_balance_cap between", value1, value2, "balanceCap");
            return (Criteria) this;
        }

        public Criteria andBalanceCapNotBetween(Integer value1, Integer value2) {
            addCriterion("F_balance_cap not between", value1, value2, "balanceCap");
            return (Criteria) this;
        }

        public Criteria andAimFlagIsNull() {
            addCriterion("F_aim_flag is null");
            return (Criteria) this;
        }

        public Criteria andAimFlagIsNotNull() {
            addCriterion("F_aim_flag is not null");
            return (Criteria) this;
        }

        public Criteria andAimFlagEqualTo(Integer value) {
            addCriterion("F_aim_flag =", value, "aimFlag");
            return (Criteria) this;
        }

        public Criteria andAimFlagNotEqualTo(Integer value) {
            addCriterion("F_aim_flag <>", value, "aimFlag");
            return (Criteria) this;
        }

        public Criteria andAimFlagGreaterThan(Integer value) {
            addCriterion("F_aim_flag >", value, "aimFlag");
            return (Criteria) this;
        }

        public Criteria andAimFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_aim_flag >=", value, "aimFlag");
            return (Criteria) this;
        }

        public Criteria andAimFlagLessThan(Integer value) {
            addCriterion("F_aim_flag <", value, "aimFlag");
            return (Criteria) this;
        }

        public Criteria andAimFlagLessThanOrEqualTo(Integer value) {
            addCriterion("F_aim_flag <=", value, "aimFlag");
            return (Criteria) this;
        }

        public Criteria andAimFlagIn(List<Integer> values) {
            addCriterion("F_aim_flag in", values, "aimFlag");
            return (Criteria) this;
        }

        public Criteria andAimFlagNotIn(List<Integer> values) {
            addCriterion("F_aim_flag not in", values, "aimFlag");
            return (Criteria) this;
        }

        public Criteria andAimFlagBetween(Integer value1, Integer value2) {
            addCriterion("F_aim_flag between", value1, value2, "aimFlag");
            return (Criteria) this;
        }

        public Criteria andAimFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("F_aim_flag not between", value1, value2, "aimFlag");
            return (Criteria) this;
        }

        public Criteria andAimFlagCapIsNull() {
            addCriterion("F_aim_flag_cap is null");
            return (Criteria) this;
        }

        public Criteria andAimFlagCapIsNotNull() {
            addCriterion("F_aim_flag_cap is not null");
            return (Criteria) this;
        }

        public Criteria andAimFlagCapEqualTo(Integer value) {
            addCriterion("F_aim_flag_cap =", value, "aimFlagCap");
            return (Criteria) this;
        }

        public Criteria andAimFlagCapNotEqualTo(Integer value) {
            addCriterion("F_aim_flag_cap <>", value, "aimFlagCap");
            return (Criteria) this;
        }

        public Criteria andAimFlagCapGreaterThan(Integer value) {
            addCriterion("F_aim_flag_cap >", value, "aimFlagCap");
            return (Criteria) this;
        }

        public Criteria andAimFlagCapGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_aim_flag_cap >=", value, "aimFlagCap");
            return (Criteria) this;
        }

        public Criteria andAimFlagCapLessThan(Integer value) {
            addCriterion("F_aim_flag_cap <", value, "aimFlagCap");
            return (Criteria) this;
        }

        public Criteria andAimFlagCapLessThanOrEqualTo(Integer value) {
            addCriterion("F_aim_flag_cap <=", value, "aimFlagCap");
            return (Criteria) this;
        }

        public Criteria andAimFlagCapIn(List<Integer> values) {
            addCriterion("F_aim_flag_cap in", values, "aimFlagCap");
            return (Criteria) this;
        }

        public Criteria andAimFlagCapNotIn(List<Integer> values) {
            addCriterion("F_aim_flag_cap not in", values, "aimFlagCap");
            return (Criteria) this;
        }

        public Criteria andAimFlagCapBetween(Integer value1, Integer value2) {
            addCriterion("F_aim_flag_cap between", value1, value2, "aimFlagCap");
            return (Criteria) this;
        }

        public Criteria andAimFlagCapNotBetween(Integer value1, Integer value2) {
            addCriterion("F_aim_flag_cap not between", value1, value2, "aimFlagCap");
            return (Criteria) this;
        }

        public Criteria andCapFlagIsNull() {
            addCriterion("F_cap_flag is null");
            return (Criteria) this;
        }

        public Criteria andCapFlagIsNotNull() {
            addCriterion("F_cap_flag is not null");
            return (Criteria) this;
        }

        public Criteria andCapFlagEqualTo(Integer value) {
            addCriterion("F_cap_flag =", value, "capFlag");
            return (Criteria) this;
        }

        public Criteria andCapFlagNotEqualTo(Integer value) {
            addCriterion("F_cap_flag <>", value, "capFlag");
            return (Criteria) this;
        }

        public Criteria andCapFlagGreaterThan(Integer value) {
            addCriterion("F_cap_flag >", value, "capFlag");
            return (Criteria) this;
        }

        public Criteria andCapFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_cap_flag >=", value, "capFlag");
            return (Criteria) this;
        }

        public Criteria andCapFlagLessThan(Integer value) {
            addCriterion("F_cap_flag <", value, "capFlag");
            return (Criteria) this;
        }

        public Criteria andCapFlagLessThanOrEqualTo(Integer value) {
            addCriterion("F_cap_flag <=", value, "capFlag");
            return (Criteria) this;
        }

        public Criteria andCapFlagIn(List<Integer> values) {
            addCriterion("F_cap_flag in", values, "capFlag");
            return (Criteria) this;
        }

        public Criteria andCapFlagNotIn(List<Integer> values) {
            addCriterion("F_cap_flag not in", values, "capFlag");
            return (Criteria) this;
        }

        public Criteria andCapFlagBetween(Integer value1, Integer value2) {
            addCriterion("F_cap_flag between", value1, value2, "capFlag");
            return (Criteria) this;
        }

        public Criteria andCapFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("F_cap_flag not between", value1, value2, "capFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagIsNull() {
            addCriterion("F_refund_flag is null");
            return (Criteria) this;
        }

        public Criteria andRefundFlagIsNotNull() {
            addCriterion("F_refund_flag is not null");
            return (Criteria) this;
        }

        public Criteria andRefundFlagEqualTo(Integer value) {
            addCriterion("F_refund_flag =", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagNotEqualTo(Integer value) {
            addCriterion("F_refund_flag <>", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagGreaterThan(Integer value) {
            addCriterion("F_refund_flag >", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_refund_flag >=", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagLessThan(Integer value) {
            addCriterion("F_refund_flag <", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagLessThanOrEqualTo(Integer value) {
            addCriterion("F_refund_flag <=", value, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagIn(List<Integer> values) {
            addCriterion("F_refund_flag in", values, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagNotIn(List<Integer> values) {
            addCriterion("F_refund_flag not in", values, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagBetween(Integer value1, Integer value2) {
            addCriterion("F_refund_flag between", value1, value2, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andRefundFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("F_refund_flag not between", value1, value2, "refundFlag");
            return (Criteria) this;
        }

        public Criteria andOperatorIsNull() {
            addCriterion("F_operator is null");
            return (Criteria) this;
        }

        public Criteria andOperatorIsNotNull() {
            addCriterion("F_operator is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorEqualTo(String value) {
            addCriterion("F_operator =", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotEqualTo(String value) {
            addCriterion("F_operator <>", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorGreaterThan(String value) {
            addCriterion("F_operator >", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorGreaterThanOrEqualTo(String value) {
            addCriterion("F_operator >=", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLessThan(String value) {
            addCriterion("F_operator <", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLessThanOrEqualTo(String value) {
            addCriterion("F_operator <=", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLike(String value) {
            addCriterion("F_operator like", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotLike(String value) {
            addCriterion("F_operator not like", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorIn(List<String> values) {
            addCriterion("F_operator in", values, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotIn(List<String> values) {
            addCriterion("F_operator not in", values, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorBetween(String value1, String value2) {
            addCriterion("F_operator between", value1, value2, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotBetween(String value1, String value2) {
            addCriterion("F_operator not between", value1, value2, "operator");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryIsNull() {
            addCriterion("F_Merchant_Industry is null");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryIsNotNull() {
            addCriterion("F_Merchant_Industry is not null");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryEqualTo(String value) {
            addCriterion("F_Merchant_Industry =", value, "merchantIndustry");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryNotEqualTo(String value) {
            addCriterion("F_Merchant_Industry <>", value, "merchantIndustry");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryGreaterThan(String value) {
            addCriterion("F_Merchant_Industry >", value, "merchantIndustry");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryGreaterThanOrEqualTo(String value) {
            addCriterion("F_Merchant_Industry >=", value, "merchantIndustry");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryLessThan(String value) {
            addCriterion("F_Merchant_Industry <", value, "merchantIndustry");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryLessThanOrEqualTo(String value) {
            addCriterion("F_Merchant_Industry <=", value, "merchantIndustry");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryLike(String value) {
            addCriterion("F_Merchant_Industry like", value, "merchantIndustry");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryNotLike(String value) {
            addCriterion("F_Merchant_Industry not like", value, "merchantIndustry");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryIn(List<String> values) {
            addCriterion("F_Merchant_Industry in", values, "merchantIndustry");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryNotIn(List<String> values) {
            addCriterion("F_Merchant_Industry not in", values, "merchantIndustry");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryBetween(String value1, String value2) {
            addCriterion("F_Merchant_Industry between", value1, value2, "merchantIndustry");
            return (Criteria) this;
        }

        public Criteria andMerchantIndustryNotBetween(String value1, String value2) {
            addCriterion("F_Merchant_Industry not between", value1, value2, "merchantIndustry");
            return (Criteria) this;
        }

        public Criteria andMccCodeIsNull() {
            addCriterion("F_Mcc_Code is null");
            return (Criteria) this;
        }

        public Criteria andMccCodeIsNotNull() {
            addCriterion("F_Mcc_Code is not null");
            return (Criteria) this;
        }

        public Criteria andMccCodeEqualTo(String value) {
            addCriterion("F_Mcc_Code =", value, "mccCode");
            return (Criteria) this;
        }

        public Criteria andMccCodeNotEqualTo(String value) {
            addCriterion("F_Mcc_Code <>", value, "mccCode");
            return (Criteria) this;
        }

        public Criteria andMccCodeGreaterThan(String value) {
            addCriterion("F_Mcc_Code >", value, "mccCode");
            return (Criteria) this;
        }

        public Criteria andMccCodeGreaterThanOrEqualTo(String value) {
            addCriterion("F_Mcc_Code >=", value, "mccCode");
            return (Criteria) this;
        }

        public Criteria andMccCodeLessThan(String value) {
            addCriterion("F_Mcc_Code <", value, "mccCode");
            return (Criteria) this;
        }

        public Criteria andMccCodeLessThanOrEqualTo(String value) {
            addCriterion("F_Mcc_Code <=", value, "mccCode");
            return (Criteria) this;
        }

        public Criteria andMccCodeLike(String value) {
            addCriterion("F_Mcc_Code like", value, "mccCode");
            return (Criteria) this;
        }

        public Criteria andMccCodeNotLike(String value) {
            addCriterion("F_Mcc_Code not like", value, "mccCode");
            return (Criteria) this;
        }

        public Criteria andMccCodeIn(List<String> values) {
            addCriterion("F_Mcc_Code in", values, "mccCode");
            return (Criteria) this;
        }

        public Criteria andMccCodeNotIn(List<String> values) {
            addCriterion("F_Mcc_Code not in", values, "mccCode");
            return (Criteria) this;
        }

        public Criteria andMccCodeBetween(String value1, String value2) {
            addCriterion("F_Mcc_Code between", value1, value2, "mccCode");
            return (Criteria) this;
        }

        public Criteria andMccCodeNotBetween(String value1, String value2) {
            addCriterion("F_Mcc_Code not between", value1, value2, "mccCode");
            return (Criteria) this;
        }

        public Criteria andRegtypeIsNull() {
            addCriterion("F_regtype is null");
            return (Criteria) this;
        }

        public Criteria andRegtypeIsNotNull() {
            addCriterion("F_regtype is not null");
            return (Criteria) this;
        }

        public Criteria andRegtypeEqualTo(Integer value) {
            addCriterion("F_regtype =", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeNotEqualTo(Integer value) {
            addCriterion("F_regtype <>", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeGreaterThan(Integer value) {
            addCriterion("F_regtype >", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_regtype >=", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeLessThan(Integer value) {
            addCriterion("F_regtype <", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeLessThanOrEqualTo(Integer value) {
            addCriterion("F_regtype <=", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeIn(List<Integer> values) {
            addCriterion("F_regtype in", values, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeNotIn(List<Integer> values) {
            addCriterion("F_regtype not in", values, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeBetween(Integer value1, Integer value2) {
            addCriterion("F_regtype between", value1, value2, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeNotBetween(Integer value1, Integer value2) {
            addCriterion("F_regtype not between", value1, value2, "regtype");
            return (Criteria) this;
        }

        public Criteria andWeiFlagIsNull() {
            addCriterion("F_wei_flag is null");
            return (Criteria) this;
        }

        public Criteria andWeiFlagIsNotNull() {
            addCriterion("F_wei_flag is not null");
            return (Criteria) this;
        }

        public Criteria andWeiFlagEqualTo(Integer value) {
            addCriterion("F_wei_flag =", value, "weiFlag");
            return (Criteria) this;
        }

        public Criteria andWeiFlagNotEqualTo(Integer value) {
            addCriterion("F_wei_flag <>", value, "weiFlag");
            return (Criteria) this;
        }

        public Criteria andWeiFlagGreaterThan(Integer value) {
            addCriterion("F_wei_flag >", value, "weiFlag");
            return (Criteria) this;
        }

        public Criteria andWeiFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_wei_flag >=", value, "weiFlag");
            return (Criteria) this;
        }

        public Criteria andWeiFlagLessThan(Integer value) {
            addCriterion("F_wei_flag <", value, "weiFlag");
            return (Criteria) this;
        }

        public Criteria andWeiFlagLessThanOrEqualTo(Integer value) {
            addCriterion("F_wei_flag <=", value, "weiFlag");
            return (Criteria) this;
        }

        public Criteria andWeiFlagIn(List<Integer> values) {
            addCriterion("F_wei_flag in", values, "weiFlag");
            return (Criteria) this;
        }

        public Criteria andWeiFlagNotIn(List<Integer> values) {
            addCriterion("F_wei_flag not in", values, "weiFlag");
            return (Criteria) this;
        }

        public Criteria andWeiFlagBetween(Integer value1, Integer value2) {
            addCriterion("F_wei_flag between", value1, value2, "weiFlag");
            return (Criteria) this;
        }

        public Criteria andWeiFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("F_wei_flag not between", value1, value2, "weiFlag");
            return (Criteria) this;
        }

        public Criteria andSellFromIsNull() {
            addCriterion("F_sell_from is null");
            return (Criteria) this;
        }

        public Criteria andSellFromIsNotNull() {
            addCriterion("F_sell_from is not null");
            return (Criteria) this;
        }

        public Criteria andSellFromEqualTo(Integer value) {
            addCriterion("F_sell_from =", value, "sellFrom");
            return (Criteria) this;
        }

        public Criteria andSellFromNotEqualTo(Integer value) {
            addCriterion("F_sell_from <>", value, "sellFrom");
            return (Criteria) this;
        }

        public Criteria andSellFromGreaterThan(Integer value) {
            addCriterion("F_sell_from >", value, "sellFrom");
            return (Criteria) this;
        }

        public Criteria andSellFromGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_sell_from >=", value, "sellFrom");
            return (Criteria) this;
        }

        public Criteria andSellFromLessThan(Integer value) {
            addCriterion("F_sell_from <", value, "sellFrom");
            return (Criteria) this;
        }

        public Criteria andSellFromLessThanOrEqualTo(Integer value) {
            addCriterion("F_sell_from <=", value, "sellFrom");
            return (Criteria) this;
        }

        public Criteria andSellFromIn(List<Integer> values) {
            addCriterion("F_sell_from in", values, "sellFrom");
            return (Criteria) this;
        }

        public Criteria andSellFromNotIn(List<Integer> values) {
            addCriterion("F_sell_from not in", values, "sellFrom");
            return (Criteria) this;
        }

        public Criteria andSellFromBetween(Integer value1, Integer value2) {
            addCriterion("F_sell_from between", value1, value2, "sellFrom");
            return (Criteria) this;
        }

        public Criteria andSellFromNotBetween(Integer value1, Integer value2) {
            addCriterion("F_sell_from not between", value1, value2, "sellFrom");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIsNull() {
            addCriterion("F_category_id is null");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIsNotNull() {
            addCriterion("F_category_id is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryIdEqualTo(Integer value) {
            addCriterion("F_category_id =", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotEqualTo(Integer value) {
            addCriterion("F_category_id <>", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThan(Integer value) {
            addCriterion("F_category_id >", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_category_id >=", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThan(Integer value) {
            addCriterion("F_category_id <", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdLessThanOrEqualTo(Integer value) {
            addCriterion("F_category_id <=", value, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdIn(List<Integer> values) {
            addCriterion("F_category_id in", values, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotIn(List<Integer> values) {
            addCriterion("F_category_id not in", values, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdBetween(Integer value1, Integer value2) {
            addCriterion("F_category_id between", value1, value2, "categoryId");
            return (Criteria) this;
        }

        public Criteria andCategoryIdNotBetween(Integer value1, Integer value2) {
            addCriterion("F_category_id not between", value1, value2, "categoryId");
            return (Criteria) this;
        }

        public Criteria andIslockIsNull() {
            addCriterion("F_islock is null");
            return (Criteria) this;
        }

        public Criteria andIslockIsNotNull() {
            addCriterion("F_islock is not null");
            return (Criteria) this;
        }

        public Criteria andIslockEqualTo(Integer value) {
            addCriterion("F_islock =", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockNotEqualTo(Integer value) {
            addCriterion("F_islock <>", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockGreaterThan(Integer value) {
            addCriterion("F_islock >", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_islock >=", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockLessThan(Integer value) {
            addCriterion("F_islock <", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockLessThanOrEqualTo(Integer value) {
            addCriterion("F_islock <=", value, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockIn(List<Integer> values) {
            addCriterion("F_islock in", values, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockNotIn(List<Integer> values) {
            addCriterion("F_islock not in", values, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockBetween(Integer value1, Integer value2) {
            addCriterion("F_islock between", value1, value2, "islock");
            return (Criteria) this;
        }

        public Criteria andIslockNotBetween(Integer value1, Integer value2) {
            addCriterion("F_islock not between", value1, value2, "islock");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeIsNull() {
            addCriterion("F_unionpay_code is null");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeIsNotNull() {
            addCriterion("F_unionpay_code is not null");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeEqualTo(String value) {
            addCriterion("F_unionpay_code =", value, "unionpayCode");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeNotEqualTo(String value) {
            addCriterion("F_unionpay_code <>", value, "unionpayCode");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeGreaterThan(String value) {
            addCriterion("F_unionpay_code >", value, "unionpayCode");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeGreaterThanOrEqualTo(String value) {
            addCriterion("F_unionpay_code >=", value, "unionpayCode");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeLessThan(String value) {
            addCriterion("F_unionpay_code <", value, "unionpayCode");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeLessThanOrEqualTo(String value) {
            addCriterion("F_unionpay_code <=", value, "unionpayCode");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeLike(String value) {
            addCriterion("F_unionpay_code like", value, "unionpayCode");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeNotLike(String value) {
            addCriterion("F_unionpay_code not like", value, "unionpayCode");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeIn(List<String> values) {
            addCriterion("F_unionpay_code in", values, "unionpayCode");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeNotIn(List<String> values) {
            addCriterion("F_unionpay_code not in", values, "unionpayCode");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeBetween(String value1, String value2) {
            addCriterion("F_unionpay_code between", value1, value2, "unionpayCode");
            return (Criteria) this;
        }

        public Criteria andUnionpayCodeNotBetween(String value1, String value2) {
            addCriterion("F_unionpay_code not between", value1, value2, "unionpayCode");
            return (Criteria) this;
        }

        public Criteria andMccTypeIsNull() {
            addCriterion("F_mcc_type is null");
            return (Criteria) this;
        }

        public Criteria andMccTypeIsNotNull() {
            addCriterion("F_mcc_type is not null");
            return (Criteria) this;
        }

        public Criteria andMccTypeEqualTo(Integer value) {
            addCriterion("F_mcc_type =", value, "mccType");
            return (Criteria) this;
        }

        public Criteria andMccTypeNotEqualTo(Integer value) {
            addCriterion("F_mcc_type <>", value, "mccType");
            return (Criteria) this;
        }

        public Criteria andMccTypeGreaterThan(Integer value) {
            addCriterion("F_mcc_type >", value, "mccType");
            return (Criteria) this;
        }

        public Criteria andMccTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_mcc_type >=", value, "mccType");
            return (Criteria) this;
        }

        public Criteria andMccTypeLessThan(Integer value) {
            addCriterion("F_mcc_type <", value, "mccType");
            return (Criteria) this;
        }

        public Criteria andMccTypeLessThanOrEqualTo(Integer value) {
            addCriterion("F_mcc_type <=", value, "mccType");
            return (Criteria) this;
        }

        public Criteria andMccTypeIn(List<Integer> values) {
            addCriterion("F_mcc_type in", values, "mccType");
            return (Criteria) this;
        }

        public Criteria andMccTypeNotIn(List<Integer> values) {
            addCriterion("F_mcc_type not in", values, "mccType");
            return (Criteria) this;
        }

        public Criteria andMccTypeBetween(Integer value1, Integer value2) {
            addCriterion("F_mcc_type between", value1, value2, "mccType");
            return (Criteria) this;
        }

        public Criteria andMccTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("F_mcc_type not between", value1, value2, "mccType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeIsNull() {
            addCriterion("F_commission_type is null");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeIsNotNull() {
            addCriterion("F_commission_type is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeEqualTo(Integer value) {
            addCriterion("F_commission_type =", value, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeNotEqualTo(Integer value) {
            addCriterion("F_commission_type <>", value, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeGreaterThan(Integer value) {
            addCriterion("F_commission_type >", value, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_commission_type >=", value, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeLessThan(Integer value) {
            addCriterion("F_commission_type <", value, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeLessThanOrEqualTo(Integer value) {
            addCriterion("F_commission_type <=", value, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeIn(List<Integer> values) {
            addCriterion("F_commission_type in", values, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeNotIn(List<Integer> values) {
            addCriterion("F_commission_type not in", values, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeBetween(Integer value1, Integer value2) {
            addCriterion("F_commission_type between", value1, value2, "commissionType");
            return (Criteria) this;
        }

        public Criteria andCommissionTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("F_commission_type not between", value1, value2, "commissionType");
            return (Criteria) this;
        }

        public Criteria andBitFlagIsNull() {
            addCriterion("F_bit_flag is null");
            return (Criteria) this;
        }

        public Criteria andBitFlagIsNotNull() {
            addCriterion("F_bit_flag is not null");
            return (Criteria) this;
        }

        public Criteria andBitFlagEqualTo(Integer value) {
            addCriterion("F_bit_flag =", value, "bitFlag");
            return (Criteria) this;
        }

        public Criteria andBitFlagNotEqualTo(Integer value) {
            addCriterion("F_bit_flag <>", value, "bitFlag");
            return (Criteria) this;
        }

        public Criteria andBitFlagGreaterThan(Integer value) {
            addCriterion("F_bit_flag >", value, "bitFlag");
            return (Criteria) this;
        }

        public Criteria andBitFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_bit_flag >=", value, "bitFlag");
            return (Criteria) this;
        }

        public Criteria andBitFlagLessThan(Integer value) {
            addCriterion("F_bit_flag <", value, "bitFlag");
            return (Criteria) this;
        }

        public Criteria andBitFlagLessThanOrEqualTo(Integer value) {
            addCriterion("F_bit_flag <=", value, "bitFlag");
            return (Criteria) this;
        }

        public Criteria andBitFlagIn(List<Integer> values) {
            addCriterion("F_bit_flag in", values, "bitFlag");
            return (Criteria) this;
        }

        public Criteria andBitFlagNotIn(List<Integer> values) {
            addCriterion("F_bit_flag not in", values, "bitFlag");
            return (Criteria) this;
        }

        public Criteria andBitFlagBetween(Integer value1, Integer value2) {
            addCriterion("F_bit_flag between", value1, value2, "bitFlag");
            return (Criteria) this;
        }

        public Criteria andBitFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("F_bit_flag not between", value1, value2, "bitFlag");
            return (Criteria) this;
        }

        public Criteria andModifyOnceBitFlagIsNull() {
            addCriterion("F_modify_once_bit_flag is null");
            return (Criteria) this;
        }

        public Criteria andModifyOnceBitFlagIsNotNull() {
            addCriterion("F_modify_once_bit_flag is not null");
            return (Criteria) this;
        }

        public Criteria andModifyOnceBitFlagEqualTo(Integer value) {
            addCriterion("F_modify_once_bit_flag =", value, "modifyOnceBitFlag");
            return (Criteria) this;
        }

        public Criteria andModifyOnceBitFlagNotEqualTo(Integer value) {
            addCriterion("F_modify_once_bit_flag <>", value, "modifyOnceBitFlag");
            return (Criteria) this;
        }

        public Criteria andModifyOnceBitFlagGreaterThan(Integer value) {
            addCriterion("F_modify_once_bit_flag >", value, "modifyOnceBitFlag");
            return (Criteria) this;
        }

        public Criteria andModifyOnceBitFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_modify_once_bit_flag >=", value, "modifyOnceBitFlag");
            return (Criteria) this;
        }

        public Criteria andModifyOnceBitFlagLessThan(Integer value) {
            addCriterion("F_modify_once_bit_flag <", value, "modifyOnceBitFlag");
            return (Criteria) this;
        }

        public Criteria andModifyOnceBitFlagLessThanOrEqualTo(Integer value) {
            addCriterion("F_modify_once_bit_flag <=", value, "modifyOnceBitFlag");
            return (Criteria) this;
        }

        public Criteria andModifyOnceBitFlagIn(List<Integer> values) {
            addCriterion("F_modify_once_bit_flag in", values, "modifyOnceBitFlag");
            return (Criteria) this;
        }

        public Criteria andModifyOnceBitFlagNotIn(List<Integer> values) {
            addCriterion("F_modify_once_bit_flag not in", values, "modifyOnceBitFlag");
            return (Criteria) this;
        }

        public Criteria andModifyOnceBitFlagBetween(Integer value1, Integer value2) {
            addCriterion("F_modify_once_bit_flag between", value1, value2, "modifyOnceBitFlag");
            return (Criteria) this;
        }

        public Criteria andModifyOnceBitFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("F_modify_once_bit_flag not between", value1, value2, "modifyOnceBitFlag");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlIsNull() {
            addCriterion("F_three_certificates_and_code_url is null");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlIsNotNull() {
            addCriterion("F_three_certificates_and_code_url is not null");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlEqualTo(String value) {
            addCriterion("F_three_certificates_and_code_url =", value, "threeCertificatesAndCodeUrl");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlNotEqualTo(String value) {
            addCriterion("F_three_certificates_and_code_url <>", value, "threeCertificatesAndCodeUrl");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlGreaterThan(String value) {
            addCriterion("F_three_certificates_and_code_url >", value, "threeCertificatesAndCodeUrl");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlGreaterThanOrEqualTo(String value) {
            addCriterion("F_three_certificates_and_code_url >=", value, "threeCertificatesAndCodeUrl");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlLessThan(String value) {
            addCriterion("F_three_certificates_and_code_url <", value, "threeCertificatesAndCodeUrl");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlLessThanOrEqualTo(String value) {
            addCriterion("F_three_certificates_and_code_url <=", value, "threeCertificatesAndCodeUrl");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlLike(String value) {
            addCriterion("F_three_certificates_and_code_url like", value, "threeCertificatesAndCodeUrl");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlNotLike(String value) {
            addCriterion("F_three_certificates_and_code_url not like", value, "threeCertificatesAndCodeUrl");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlIn(List<String> values) {
            addCriterion("F_three_certificates_and_code_url in", values, "threeCertificatesAndCodeUrl");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlNotIn(List<String> values) {
            addCriterion("F_three_certificates_and_code_url not in", values, "threeCertificatesAndCodeUrl");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlBetween(String value1, String value2) {
            addCriterion("F_three_certificates_and_code_url between", value1, value2, "threeCertificatesAndCodeUrl");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeUrlNotBetween(String value1, String value2) {
            addCriterion("F_three_certificates_and_code_url not between", value1, value2, "threeCertificatesAndCodeUrl");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeIsNull() {
            addCriterion("F_three_certificates_and_code is null");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeIsNotNull() {
            addCriterion("F_three_certificates_and_code is not null");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeEqualTo(String value) {
            addCriterion("F_three_certificates_and_code =", value, "threeCertificatesAndCode");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeNotEqualTo(String value) {
            addCriterion("F_three_certificates_and_code <>", value, "threeCertificatesAndCode");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeGreaterThan(String value) {
            addCriterion("F_three_certificates_and_code >", value, "threeCertificatesAndCode");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeGreaterThanOrEqualTo(String value) {
            addCriterion("F_three_certificates_and_code >=", value, "threeCertificatesAndCode");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeLessThan(String value) {
            addCriterion("F_three_certificates_and_code <", value, "threeCertificatesAndCode");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeLessThanOrEqualTo(String value) {
            addCriterion("F_three_certificates_and_code <=", value, "threeCertificatesAndCode");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeLike(String value) {
            addCriterion("F_three_certificates_and_code like", value, "threeCertificatesAndCode");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeNotLike(String value) {
            addCriterion("F_three_certificates_and_code not like", value, "threeCertificatesAndCode");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeIn(List<String> values) {
            addCriterion("F_three_certificates_and_code in", values, "threeCertificatesAndCode");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeNotIn(List<String> values) {
            addCriterion("F_three_certificates_and_code not in", values, "threeCertificatesAndCode");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeBetween(String value1, String value2) {
            addCriterion("F_three_certificates_and_code between", value1, value2, "threeCertificatesAndCode");
            return (Criteria) this;
        }

        public Criteria andThreeCertificatesAndCodeNotBetween(String value1, String value2) {
            addCriterion("F_three_certificates_and_code not between", value1, value2, "threeCertificatesAndCode");
            return (Criteria) this;
        }

        public Criteria andIdcardStartIsNull() {
            addCriterion("F_idcard_start is null");
            return (Criteria) this;
        }

        public Criteria andIdcardStartIsNotNull() {
            addCriterion("F_idcard_start is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardStartEqualTo(String value) {
            addCriterion("F_idcard_start =", value, "idcardStart");
            return (Criteria) this;
        }

        public Criteria andIdcardStartNotEqualTo(String value) {
            addCriterion("F_idcard_start <>", value, "idcardStart");
            return (Criteria) this;
        }

        public Criteria andIdcardStartGreaterThan(String value) {
            addCriterion("F_idcard_start >", value, "idcardStart");
            return (Criteria) this;
        }

        public Criteria andIdcardStartGreaterThanOrEqualTo(String value) {
            addCriterion("F_idcard_start >=", value, "idcardStart");
            return (Criteria) this;
        }

        public Criteria andIdcardStartLessThan(String value) {
            addCriterion("F_idcard_start <", value, "idcardStart");
            return (Criteria) this;
        }

        public Criteria andIdcardStartLessThanOrEqualTo(String value) {
            addCriterion("F_idcard_start <=", value, "idcardStart");
            return (Criteria) this;
        }

        public Criteria andIdcardStartLike(String value) {
            addCriterion("F_idcard_start like", value, "idcardStart");
            return (Criteria) this;
        }

        public Criteria andIdcardStartNotLike(String value) {
            addCriterion("F_idcard_start not like", value, "idcardStart");
            return (Criteria) this;
        }

        public Criteria andIdcardStartIn(List<String> values) {
            addCriterion("F_idcard_start in", values, "idcardStart");
            return (Criteria) this;
        }

        public Criteria andIdcardStartNotIn(List<String> values) {
            addCriterion("F_idcard_start not in", values, "idcardStart");
            return (Criteria) this;
        }

        public Criteria andIdcardStartBetween(String value1, String value2) {
            addCriterion("F_idcard_start between", value1, value2, "idcardStart");
            return (Criteria) this;
        }

        public Criteria andIdcardStartNotBetween(String value1, String value2) {
            addCriterion("F_idcard_start not between", value1, value2, "idcardStart");
            return (Criteria) this;
        }

        public Criteria andIdcardEndIsNull() {
            addCriterion("F_idcard_end is null");
            return (Criteria) this;
        }

        public Criteria andIdcardEndIsNotNull() {
            addCriterion("F_idcard_end is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardEndEqualTo(String value) {
            addCriterion("F_idcard_end =", value, "idcardEnd");
            return (Criteria) this;
        }

        public Criteria andIdcardEndNotEqualTo(String value) {
            addCriterion("F_idcard_end <>", value, "idcardEnd");
            return (Criteria) this;
        }

        public Criteria andIdcardEndGreaterThan(String value) {
            addCriterion("F_idcard_end >", value, "idcardEnd");
            return (Criteria) this;
        }

        public Criteria andIdcardEndGreaterThanOrEqualTo(String value) {
            addCriterion("F_idcard_end >=", value, "idcardEnd");
            return (Criteria) this;
        }

        public Criteria andIdcardEndLessThan(String value) {
            addCriterion("F_idcard_end <", value, "idcardEnd");
            return (Criteria) this;
        }

        public Criteria andIdcardEndLessThanOrEqualTo(String value) {
            addCriterion("F_idcard_end <=", value, "idcardEnd");
            return (Criteria) this;
        }

        public Criteria andIdcardEndLike(String value) {
            addCriterion("F_idcard_end like", value, "idcardEnd");
            return (Criteria) this;
        }

        public Criteria andIdcardEndNotLike(String value) {
            addCriterion("F_idcard_end not like", value, "idcardEnd");
            return (Criteria) this;
        }

        public Criteria andIdcardEndIn(List<String> values) {
            addCriterion("F_idcard_end in", values, "idcardEnd");
            return (Criteria) this;
        }

        public Criteria andIdcardEndNotIn(List<String> values) {
            addCriterion("F_idcard_end not in", values, "idcardEnd");
            return (Criteria) this;
        }

        public Criteria andIdcardEndBetween(String value1, String value2) {
            addCriterion("F_idcard_end between", value1, value2, "idcardEnd");
            return (Criteria) this;
        }

        public Criteria andIdcardEndNotBetween(String value1, String value2) {
            addCriterion("F_idcard_end not between", value1, value2, "idcardEnd");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeIsNull() {
            addCriterion("F_bank_account_licence_code is null");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeIsNotNull() {
            addCriterion("F_bank_account_licence_code is not null");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeEqualTo(String value) {
            addCriterion("F_bank_account_licence_code =", value, "bankAccountLicenceCode");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeNotEqualTo(String value) {
            addCriterion("F_bank_account_licence_code <>", value, "bankAccountLicenceCode");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeGreaterThan(String value) {
            addCriterion("F_bank_account_licence_code >", value, "bankAccountLicenceCode");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeGreaterThanOrEqualTo(String value) {
            addCriterion("F_bank_account_licence_code >=", value, "bankAccountLicenceCode");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeLessThan(String value) {
            addCriterion("F_bank_account_licence_code <", value, "bankAccountLicenceCode");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeLessThanOrEqualTo(String value) {
            addCriterion("F_bank_account_licence_code <=", value, "bankAccountLicenceCode");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeLike(String value) {
            addCriterion("F_bank_account_licence_code like", value, "bankAccountLicenceCode");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeNotLike(String value) {
            addCriterion("F_bank_account_licence_code not like", value, "bankAccountLicenceCode");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeIn(List<String> values) {
            addCriterion("F_bank_account_licence_code in", values, "bankAccountLicenceCode");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeNotIn(List<String> values) {
            addCriterion("F_bank_account_licence_code not in", values, "bankAccountLicenceCode");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeBetween(String value1, String value2) {
            addCriterion("F_bank_account_licence_code between", value1, value2, "bankAccountLicenceCode");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceCodeNotBetween(String value1, String value2) {
            addCriterion("F_bank_account_licence_code not between", value1, value2, "bankAccountLicenceCode");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlIsNull() {
            addCriterion("F_bank_account_licence_url is null");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlIsNotNull() {
            addCriterion("F_bank_account_licence_url is not null");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlEqualTo(String value) {
            addCriterion("F_bank_account_licence_url =", value, "bankAccountLicenceUrl");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlNotEqualTo(String value) {
            addCriterion("F_bank_account_licence_url <>", value, "bankAccountLicenceUrl");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlGreaterThan(String value) {
            addCriterion("F_bank_account_licence_url >", value, "bankAccountLicenceUrl");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlGreaterThanOrEqualTo(String value) {
            addCriterion("F_bank_account_licence_url >=", value, "bankAccountLicenceUrl");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlLessThan(String value) {
            addCriterion("F_bank_account_licence_url <", value, "bankAccountLicenceUrl");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlLessThanOrEqualTo(String value) {
            addCriterion("F_bank_account_licence_url <=", value, "bankAccountLicenceUrl");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlLike(String value) {
            addCriterion("F_bank_account_licence_url like", value, "bankAccountLicenceUrl");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlNotLike(String value) {
            addCriterion("F_bank_account_licence_url not like", value, "bankAccountLicenceUrl");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlIn(List<String> values) {
            addCriterion("F_bank_account_licence_url in", values, "bankAccountLicenceUrl");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlNotIn(List<String> values) {
            addCriterion("F_bank_account_licence_url not in", values, "bankAccountLicenceUrl");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlBetween(String value1, String value2) {
            addCriterion("F_bank_account_licence_url between", value1, value2, "bankAccountLicenceUrl");
            return (Criteria) this;
        }

        public Criteria andBankAccountLicenceUrlNotBetween(String value1, String value2) {
            addCriterion("F_bank_account_licence_url not between", value1, value2, "bankAccountLicenceUrl");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeIsNull() {
            addCriterion("F_personal_tax_prove_code is null");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeIsNotNull() {
            addCriterion("F_personal_tax_prove_code is not null");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeEqualTo(String value) {
            addCriterion("F_personal_tax_prove_code =", value, "personalTaxProveCode");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeNotEqualTo(String value) {
            addCriterion("F_personal_tax_prove_code <>", value, "personalTaxProveCode");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeGreaterThan(String value) {
            addCriterion("F_personal_tax_prove_code >", value, "personalTaxProveCode");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeGreaterThanOrEqualTo(String value) {
            addCriterion("F_personal_tax_prove_code >=", value, "personalTaxProveCode");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeLessThan(String value) {
            addCriterion("F_personal_tax_prove_code <", value, "personalTaxProveCode");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeLessThanOrEqualTo(String value) {
            addCriterion("F_personal_tax_prove_code <=", value, "personalTaxProveCode");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeLike(String value) {
            addCriterion("F_personal_tax_prove_code like", value, "personalTaxProveCode");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeNotLike(String value) {
            addCriterion("F_personal_tax_prove_code not like", value, "personalTaxProveCode");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeIn(List<String> values) {
            addCriterion("F_personal_tax_prove_code in", values, "personalTaxProveCode");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeNotIn(List<String> values) {
            addCriterion("F_personal_tax_prove_code not in", values, "personalTaxProveCode");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeBetween(String value1, String value2) {
            addCriterion("F_personal_tax_prove_code between", value1, value2, "personalTaxProveCode");
            return (Criteria) this;
        }

        public Criteria andPersonalTaxProveCodeNotBetween(String value1, String value2) {
            addCriterion("F_personal_tax_prove_code not between", value1, value2, "personalTaxProveCode");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingIsNull() {
            addCriterion("F_organization_code_coding is null");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingIsNotNull() {
            addCriterion("F_organization_code_coding is not null");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingEqualTo(String value) {
            addCriterion("F_organization_code_coding =", value, "organizationCodeCoding");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingNotEqualTo(String value) {
            addCriterion("F_organization_code_coding <>", value, "organizationCodeCoding");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingGreaterThan(String value) {
            addCriterion("F_organization_code_coding >", value, "organizationCodeCoding");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingGreaterThanOrEqualTo(String value) {
            addCriterion("F_organization_code_coding >=", value, "organizationCodeCoding");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingLessThan(String value) {
            addCriterion("F_organization_code_coding <", value, "organizationCodeCoding");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingLessThanOrEqualTo(String value) {
            addCriterion("F_organization_code_coding <=", value, "organizationCodeCoding");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingLike(String value) {
            addCriterion("F_organization_code_coding like", value, "organizationCodeCoding");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingNotLike(String value) {
            addCriterion("F_organization_code_coding not like", value, "organizationCodeCoding");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingIn(List<String> values) {
            addCriterion("F_organization_code_coding in", values, "organizationCodeCoding");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingNotIn(List<String> values) {
            addCriterion("F_organization_code_coding not in", values, "organizationCodeCoding");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingBetween(String value1, String value2) {
            addCriterion("F_organization_code_coding between", value1, value2, "organizationCodeCoding");
            return (Criteria) this;
        }

        public Criteria andOrganizationCodeCodingNotBetween(String value1, String value2) {
            addCriterion("F_organization_code_coding not between", value1, value2, "organizationCodeCoding");
            return (Criteria) this;
        }

        public Criteria andCommissionByWeixinIsNull() {
            addCriterion("F_commission_by_weixin is null");
            return (Criteria) this;
        }

        public Criteria andCommissionByWeixinIsNotNull() {
            addCriterion("F_commission_by_weixin is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionByWeixinEqualTo(Integer value) {
            addCriterion("F_commission_by_weixin =", value, "commissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andCommissionByWeixinNotEqualTo(Integer value) {
            addCriterion("F_commission_by_weixin <>", value, "commissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andCommissionByWeixinGreaterThan(Integer value) {
            addCriterion("F_commission_by_weixin >", value, "commissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andCommissionByWeixinGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_commission_by_weixin >=", value, "commissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andCommissionByWeixinLessThan(Integer value) {
            addCriterion("F_commission_by_weixin <", value, "commissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andCommissionByWeixinLessThanOrEqualTo(Integer value) {
            addCriterion("F_commission_by_weixin <=", value, "commissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andCommissionByWeixinIn(List<Integer> values) {
            addCriterion("F_commission_by_weixin in", values, "commissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andCommissionByWeixinNotIn(List<Integer> values) {
            addCriterion("F_commission_by_weixin not in", values, "commissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andCommissionByWeixinBetween(Integer value1, Integer value2) {
            addCriterion("F_commission_by_weixin between", value1, value2, "commissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andCommissionByWeixinNotBetween(Integer value1, Integer value2) {
            addCriterion("F_commission_by_weixin not between", value1, value2, "commissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andSpIdIsNull() {
            addCriterion("F_sp_id is null");
            return (Criteria) this;
        }

        public Criteria andSpIdIsNotNull() {
            addCriterion("F_sp_id is not null");
            return (Criteria) this;
        }

        public Criteria andSpIdEqualTo(Integer value) {
            addCriterion("F_sp_id =", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdNotEqualTo(Integer value) {
            addCriterion("F_sp_id <>", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdGreaterThan(Integer value) {
            addCriterion("F_sp_id >", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_sp_id >=", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdLessThan(Integer value) {
            addCriterion("F_sp_id <", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdLessThanOrEqualTo(Integer value) {
            addCriterion("F_sp_id <=", value, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdIn(List<Integer> values) {
            addCriterion("F_sp_id in", values, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdNotIn(List<Integer> values) {
            addCriterion("F_sp_id not in", values, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdBetween(Integer value1, Integer value2) {
            addCriterion("F_sp_id between", value1, value2, "spId");
            return (Criteria) this;
        }

        public Criteria andSpIdNotBetween(Integer value1, Integer value2) {
            addCriterion("F_sp_id not between", value1, value2, "spId");
            return (Criteria) this;
        }

        public Criteria andCommissionByAlipayIsNull() {
            addCriterion("F_commission_by_alipay is null");
            return (Criteria) this;
        }

        public Criteria andCommissionByAlipayIsNotNull() {
            addCriterion("F_commission_by_alipay is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionByAlipayEqualTo(Integer value) {
            addCriterion("F_commission_by_alipay =", value, "commissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andCommissionByAlipayNotEqualTo(Integer value) {
            addCriterion("F_commission_by_alipay <>", value, "commissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andCommissionByAlipayGreaterThan(Integer value) {
            addCriterion("F_commission_by_alipay >", value, "commissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andCommissionByAlipayGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_commission_by_alipay >=", value, "commissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andCommissionByAlipayLessThan(Integer value) {
            addCriterion("F_commission_by_alipay <", value, "commissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andCommissionByAlipayLessThanOrEqualTo(Integer value) {
            addCriterion("F_commission_by_alipay <=", value, "commissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andCommissionByAlipayIn(List<Integer> values) {
            addCriterion("F_commission_by_alipay in", values, "commissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andCommissionByAlipayNotIn(List<Integer> values) {
            addCriterion("F_commission_by_alipay not in", values, "commissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andCommissionByAlipayBetween(Integer value1, Integer value2) {
            addCriterion("F_commission_by_alipay between", value1, value2, "commissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andCommissionByAlipayNotBetween(Integer value1, Integer value2) {
            addCriterion("F_commission_by_alipay not between", value1, value2, "commissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andBusinessMiaodaoActivityIsNull() {
            addCriterion("F_business_miaodao_activity is null");
            return (Criteria) this;
        }

        public Criteria andBusinessMiaodaoActivityIsNotNull() {
            addCriterion("F_business_miaodao_activity is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessMiaodaoActivityEqualTo(Integer value) {
            addCriterion("F_business_miaodao_activity =", value, "businessMiaodaoActivity");
            return (Criteria) this;
        }

        public Criteria andBusinessMiaodaoActivityNotEqualTo(Integer value) {
            addCriterion("F_business_miaodao_activity <>", value, "businessMiaodaoActivity");
            return (Criteria) this;
        }

        public Criteria andBusinessMiaodaoActivityGreaterThan(Integer value) {
            addCriterion("F_business_miaodao_activity >", value, "businessMiaodaoActivity");
            return (Criteria) this;
        }

        public Criteria andBusinessMiaodaoActivityGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_business_miaodao_activity >=", value, "businessMiaodaoActivity");
            return (Criteria) this;
        }

        public Criteria andBusinessMiaodaoActivityLessThan(Integer value) {
            addCriterion("F_business_miaodao_activity <", value, "businessMiaodaoActivity");
            return (Criteria) this;
        }

        public Criteria andBusinessMiaodaoActivityLessThanOrEqualTo(Integer value) {
            addCriterion("F_business_miaodao_activity <=", value, "businessMiaodaoActivity");
            return (Criteria) this;
        }

        public Criteria andBusinessMiaodaoActivityIn(List<Integer> values) {
            addCriterion("F_business_miaodao_activity in", values, "businessMiaodaoActivity");
            return (Criteria) this;
        }

        public Criteria andBusinessMiaodaoActivityNotIn(List<Integer> values) {
            addCriterion("F_business_miaodao_activity not in", values, "businessMiaodaoActivity");
            return (Criteria) this;
        }

        public Criteria andBusinessMiaodaoActivityBetween(Integer value1, Integer value2) {
            addCriterion("F_business_miaodao_activity between", value1, value2, "businessMiaodaoActivity");
            return (Criteria) this;
        }

        public Criteria andBusinessMiaodaoActivityNotBetween(Integer value1, Integer value2) {
            addCriterion("F_business_miaodao_activity not between", value1, value2, "businessMiaodaoActivity");
            return (Criteria) this;
        }

        public Criteria andWxClassIsNull() {
            addCriterion("F_wx_class is null");
            return (Criteria) this;
        }

        public Criteria andWxClassIsNotNull() {
            addCriterion("F_wx_class is not null");
            return (Criteria) this;
        }

        public Criteria andWxClassEqualTo(Integer value) {
            addCriterion("F_wx_class =", value, "wxClass");
            return (Criteria) this;
        }

        public Criteria andWxClassNotEqualTo(Integer value) {
            addCriterion("F_wx_class <>", value, "wxClass");
            return (Criteria) this;
        }

        public Criteria andWxClassGreaterThan(Integer value) {
            addCriterion("F_wx_class >", value, "wxClass");
            return (Criteria) this;
        }

        public Criteria andWxClassGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_wx_class >=", value, "wxClass");
            return (Criteria) this;
        }

        public Criteria andWxClassLessThan(Integer value) {
            addCriterion("F_wx_class <", value, "wxClass");
            return (Criteria) this;
        }

        public Criteria andWxClassLessThanOrEqualTo(Integer value) {
            addCriterion("F_wx_class <=", value, "wxClass");
            return (Criteria) this;
        }

        public Criteria andWxClassIn(List<Integer> values) {
            addCriterion("F_wx_class in", values, "wxClass");
            return (Criteria) this;
        }

        public Criteria andWxClassNotIn(List<Integer> values) {
            addCriterion("F_wx_class not in", values, "wxClass");
            return (Criteria) this;
        }

        public Criteria andWxClassBetween(Integer value1, Integer value2) {
            addCriterion("F_wx_class between", value1, value2, "wxClass");
            return (Criteria) this;
        }

        public Criteria andWxClassNotBetween(Integer value1, Integer value2) {
            addCriterion("F_wx_class not between", value1, value2, "wxClass");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneIsNull() {
            addCriterion("F_bankcard_phone is null");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneIsNotNull() {
            addCriterion("F_bankcard_phone is not null");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEqualTo(String value) {
            addCriterion("F_bankcard_phone =", value, "bankcardPhone");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneNotEqualTo(String value) {
            addCriterion("F_bankcard_phone <>", value, "bankcardPhone");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneGreaterThan(String value) {
            addCriterion("F_bankcard_phone >", value, "bankcardPhone");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("F_bankcard_phone >=", value, "bankcardPhone");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneLessThan(String value) {
            addCriterion("F_bankcard_phone <", value, "bankcardPhone");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneLessThanOrEqualTo(String value) {
            addCriterion("F_bankcard_phone <=", value, "bankcardPhone");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneLike(String value) {
            addCriterion("F_bankcard_phone like", value, "bankcardPhone");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneNotLike(String value) {
            addCriterion("F_bankcard_phone not like", value, "bankcardPhone");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneIn(List<String> values) {
            addCriterion("F_bankcard_phone in", values, "bankcardPhone");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneNotIn(List<String> values) {
            addCriterion("F_bankcard_phone not in", values, "bankcardPhone");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneBetween(String value1, String value2) {
            addCriterion("F_bankcard_phone between", value1, value2, "bankcardPhone");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneNotBetween(String value1, String value2) {
            addCriterion("F_bankcard_phone not between", value1, value2, "bankcardPhone");
            return (Criteria) this;
        }

        public Criteria andPrivilegeLevelIsNull() {
            addCriterion("F_privilege_level is null");
            return (Criteria) this;
        }

        public Criteria andPrivilegeLevelIsNotNull() {
            addCriterion("F_privilege_level is not null");
            return (Criteria) this;
        }

        public Criteria andPrivilegeLevelEqualTo(Integer value) {
            addCriterion("F_privilege_level =", value, "privilegeLevel");
            return (Criteria) this;
        }

        public Criteria andPrivilegeLevelNotEqualTo(Integer value) {
            addCriterion("F_privilege_level <>", value, "privilegeLevel");
            return (Criteria) this;
        }

        public Criteria andPrivilegeLevelGreaterThan(Integer value) {
            addCriterion("F_privilege_level >", value, "privilegeLevel");
            return (Criteria) this;
        }

        public Criteria andPrivilegeLevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_privilege_level >=", value, "privilegeLevel");
            return (Criteria) this;
        }

        public Criteria andPrivilegeLevelLessThan(Integer value) {
            addCriterion("F_privilege_level <", value, "privilegeLevel");
            return (Criteria) this;
        }

        public Criteria andPrivilegeLevelLessThanOrEqualTo(Integer value) {
            addCriterion("F_privilege_level <=", value, "privilegeLevel");
            return (Criteria) this;
        }

        public Criteria andPrivilegeLevelIn(List<Integer> values) {
            addCriterion("F_privilege_level in", values, "privilegeLevel");
            return (Criteria) this;
        }

        public Criteria andPrivilegeLevelNotIn(List<Integer> values) {
            addCriterion("F_privilege_level not in", values, "privilegeLevel");
            return (Criteria) this;
        }

        public Criteria andPrivilegeLevelBetween(Integer value1, Integer value2) {
            addCriterion("F_privilege_level between", value1, value2, "privilegeLevel");
            return (Criteria) this;
        }

        public Criteria andPrivilegeLevelNotBetween(Integer value1, Integer value2) {
            addCriterion("F_privilege_level not between", value1, value2, "privilegeLevel");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("F_update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("F_update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("F_update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("F_update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("F_update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("F_update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("F_update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("F_update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("F_update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("F_update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("F_update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("F_update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andPreferentialTypeIsNull() {
            addCriterion("F_preferential_type is null");
            return (Criteria) this;
        }

        public Criteria andPreferentialTypeIsNotNull() {
            addCriterion("F_preferential_type is not null");
            return (Criteria) this;
        }

        public Criteria andPreferentialTypeEqualTo(Integer value) {
            addCriterion("F_preferential_type =", value, "preferentialType");
            return (Criteria) this;
        }

        public Criteria andPreferentialTypeNotEqualTo(Integer value) {
            addCriterion("F_preferential_type <>", value, "preferentialType");
            return (Criteria) this;
        }

        public Criteria andPreferentialTypeGreaterThan(Integer value) {
            addCriterion("F_preferential_type >", value, "preferentialType");
            return (Criteria) this;
        }

        public Criteria andPreferentialTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_preferential_type >=", value, "preferentialType");
            return (Criteria) this;
        }

        public Criteria andPreferentialTypeLessThan(Integer value) {
            addCriterion("F_preferential_type <", value, "preferentialType");
            return (Criteria) this;
        }

        public Criteria andPreferentialTypeLessThanOrEqualTo(Integer value) {
            addCriterion("F_preferential_type <=", value, "preferentialType");
            return (Criteria) this;
        }

        public Criteria andPreferentialTypeIn(List<Integer> values) {
            addCriterion("F_preferential_type in", values, "preferentialType");
            return (Criteria) this;
        }

        public Criteria andPreferentialTypeNotIn(List<Integer> values) {
            addCriterion("F_preferential_type not in", values, "preferentialType");
            return (Criteria) this;
        }

        public Criteria andPreferentialTypeBetween(Integer value1, Integer value2) {
            addCriterion("F_preferential_type between", value1, value2, "preferentialType");
            return (Criteria) this;
        }

        public Criteria andPreferentialTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("F_preferential_type not between", value1, value2, "preferentialType");
            return (Criteria) this;
        }

        public Criteria andT0ProgrammeFlagIsNull() {
            addCriterion("F_t0_programme_flag is null");
            return (Criteria) this;
        }

        public Criteria andT0ProgrammeFlagIsNotNull() {
            addCriterion("F_t0_programme_flag is not null");
            return (Criteria) this;
        }

        public Criteria andT0ProgrammeFlagEqualTo(Integer value) {
            addCriterion("F_t0_programme_flag =", value, "t0ProgrammeFlag");
            return (Criteria) this;
        }

        public Criteria andT0ProgrammeFlagNotEqualTo(Integer value) {
            addCriterion("F_t0_programme_flag <>", value, "t0ProgrammeFlag");
            return (Criteria) this;
        }

        public Criteria andT0ProgrammeFlagGreaterThan(Integer value) {
            addCriterion("F_t0_programme_flag >", value, "t0ProgrammeFlag");
            return (Criteria) this;
        }

        public Criteria andT0ProgrammeFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_t0_programme_flag >=", value, "t0ProgrammeFlag");
            return (Criteria) this;
        }

        public Criteria andT0ProgrammeFlagLessThan(Integer value) {
            addCriterion("F_t0_programme_flag <", value, "t0ProgrammeFlag");
            return (Criteria) this;
        }

        public Criteria andT0ProgrammeFlagLessThanOrEqualTo(Integer value) {
            addCriterion("F_t0_programme_flag <=", value, "t0ProgrammeFlag");
            return (Criteria) this;
        }

        public Criteria andT0ProgrammeFlagIn(List<Integer> values) {
            addCriterion("F_t0_programme_flag in", values, "t0ProgrammeFlag");
            return (Criteria) this;
        }

        public Criteria andT0ProgrammeFlagNotIn(List<Integer> values) {
            addCriterion("F_t0_programme_flag not in", values, "t0ProgrammeFlag");
            return (Criteria) this;
        }

        public Criteria andT0ProgrammeFlagBetween(Integer value1, Integer value2) {
            addCriterion("F_t0_programme_flag between", value1, value2, "t0ProgrammeFlag");
            return (Criteria) this;
        }

        public Criteria andT0ProgrammeFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("F_t0_programme_flag not between", value1, value2, "t0ProgrammeFlag");
            return (Criteria) this;
        }

        public Criteria andT0MaxFlagIsNull() {
            addCriterion("F_t0_max_flag is null");
            return (Criteria) this;
        }

        public Criteria andT0MaxFlagIsNotNull() {
            addCriterion("F_t0_max_flag is not null");
            return (Criteria) this;
        }

        public Criteria andT0MaxFlagEqualTo(Integer value) {
            addCriterion("F_t0_max_flag =", value, "t0MaxFlag");
            return (Criteria) this;
        }

        public Criteria andT0MaxFlagNotEqualTo(Integer value) {
            addCriterion("F_t0_max_flag <>", value, "t0MaxFlag");
            return (Criteria) this;
        }

        public Criteria andT0MaxFlagGreaterThan(Integer value) {
            addCriterion("F_t0_max_flag >", value, "t0MaxFlag");
            return (Criteria) this;
        }

        public Criteria andT0MaxFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_t0_max_flag >=", value, "t0MaxFlag");
            return (Criteria) this;
        }

        public Criteria andT0MaxFlagLessThan(Integer value) {
            addCriterion("F_t0_max_flag <", value, "t0MaxFlag");
            return (Criteria) this;
        }

        public Criteria andT0MaxFlagLessThanOrEqualTo(Integer value) {
            addCriterion("F_t0_max_flag <=", value, "t0MaxFlag");
            return (Criteria) this;
        }

        public Criteria andT0MaxFlagIn(List<Integer> values) {
            addCriterion("F_t0_max_flag in", values, "t0MaxFlag");
            return (Criteria) this;
        }

        public Criteria andT0MaxFlagNotIn(List<Integer> values) {
            addCriterion("F_t0_max_flag not in", values, "t0MaxFlag");
            return (Criteria) this;
        }

        public Criteria andT0MaxFlagBetween(Integer value1, Integer value2) {
            addCriterion("F_t0_max_flag between", value1, value2, "t0MaxFlag");
            return (Criteria) this;
        }

        public Criteria andT0MaxFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("F_t0_max_flag not between", value1, value2, "t0MaxFlag");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByWeixinIsNull() {
            addCriterion("F_t0_commission_by_weixin is null");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByWeixinIsNotNull() {
            addCriterion("F_t0_commission_by_weixin is not null");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByWeixinEqualTo(Integer value) {
            addCriterion("F_t0_commission_by_weixin =", value, "t0CommissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByWeixinNotEqualTo(Integer value) {
            addCriterion("F_t0_commission_by_weixin <>", value, "t0CommissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByWeixinGreaterThan(Integer value) {
            addCriterion("F_t0_commission_by_weixin >", value, "t0CommissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByWeixinGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_t0_commission_by_weixin >=", value, "t0CommissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByWeixinLessThan(Integer value) {
            addCriterion("F_t0_commission_by_weixin <", value, "t0CommissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByWeixinLessThanOrEqualTo(Integer value) {
            addCriterion("F_t0_commission_by_weixin <=", value, "t0CommissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByWeixinIn(List<Integer> values) {
            addCriterion("F_t0_commission_by_weixin in", values, "t0CommissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByWeixinNotIn(List<Integer> values) {
            addCriterion("F_t0_commission_by_weixin not in", values, "t0CommissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByWeixinBetween(Integer value1, Integer value2) {
            addCriterion("F_t0_commission_by_weixin between", value1, value2, "t0CommissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByWeixinNotBetween(Integer value1, Integer value2) {
            addCriterion("F_t0_commission_by_weixin not between", value1, value2, "t0CommissionByWeixin");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByAlipayIsNull() {
            addCriterion("F_t0_commission_by_alipay is null");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByAlipayIsNotNull() {
            addCriterion("F_t0_commission_by_alipay is not null");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByAlipayEqualTo(Integer value) {
            addCriterion("F_t0_commission_by_alipay =", value, "t0CommissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByAlipayNotEqualTo(Integer value) {
            addCriterion("F_t0_commission_by_alipay <>", value, "t0CommissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByAlipayGreaterThan(Integer value) {
            addCriterion("F_t0_commission_by_alipay >", value, "t0CommissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByAlipayGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_t0_commission_by_alipay >=", value, "t0CommissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByAlipayLessThan(Integer value) {
            addCriterion("F_t0_commission_by_alipay <", value, "t0CommissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByAlipayLessThanOrEqualTo(Integer value) {
            addCriterion("F_t0_commission_by_alipay <=", value, "t0CommissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByAlipayIn(List<Integer> values) {
            addCriterion("F_t0_commission_by_alipay in", values, "t0CommissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByAlipayNotIn(List<Integer> values) {
            addCriterion("F_t0_commission_by_alipay not in", values, "t0CommissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByAlipayBetween(Integer value1, Integer value2) {
            addCriterion("F_t0_commission_by_alipay between", value1, value2, "t0CommissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andT0CommissionByAlipayNotBetween(Integer value1, Integer value2) {
            addCriterion("F_t0_commission_by_alipay not between", value1, value2, "t0CommissionByAlipay");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardCommissionIsNull() {
            addCriterion("F_t1_debit_card_commission is null");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardCommissionIsNotNull() {
            addCriterion("F_t1_debit_card_commission is not null");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardCommissionEqualTo(Long value) {
            addCriterion("F_t1_debit_card_commission =", value, "t1DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardCommissionNotEqualTo(Long value) {
            addCriterion("F_t1_debit_card_commission <>", value, "t1DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardCommissionGreaterThan(Long value) {
            addCriterion("F_t1_debit_card_commission >", value, "t1DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardCommissionGreaterThanOrEqualTo(Long value) {
            addCriterion("F_t1_debit_card_commission >=", value, "t1DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardCommissionLessThan(Long value) {
            addCriterion("F_t1_debit_card_commission <", value, "t1DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardCommissionLessThanOrEqualTo(Long value) {
            addCriterion("F_t1_debit_card_commission <=", value, "t1DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardCommissionIn(List<Long> values) {
            addCriterion("F_t1_debit_card_commission in", values, "t1DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardCommissionNotIn(List<Long> values) {
            addCriterion("F_t1_debit_card_commission not in", values, "t1DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardCommissionBetween(Long value1, Long value2) {
            addCriterion("F_t1_debit_card_commission between", value1, value2, "t1DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardCommissionNotBetween(Long value1, Long value2) {
            addCriterion("F_t1_debit_card_commission not between", value1, value2, "t1DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardMaxFeeIsNull() {
            addCriterion("F_t1_debit_card_max_fee is null");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardMaxFeeIsNotNull() {
            addCriterion("F_t1_debit_card_max_fee is not null");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardMaxFeeEqualTo(Long value) {
            addCriterion("F_t1_debit_card_max_fee =", value, "t1DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardMaxFeeNotEqualTo(Long value) {
            addCriterion("F_t1_debit_card_max_fee <>", value, "t1DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardMaxFeeGreaterThan(Long value) {
            addCriterion("F_t1_debit_card_max_fee >", value, "t1DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardMaxFeeGreaterThanOrEqualTo(Long value) {
            addCriterion("F_t1_debit_card_max_fee >=", value, "t1DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardMaxFeeLessThan(Long value) {
            addCriterion("F_t1_debit_card_max_fee <", value, "t1DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardMaxFeeLessThanOrEqualTo(Long value) {
            addCriterion("F_t1_debit_card_max_fee <=", value, "t1DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardMaxFeeIn(List<Long> values) {
            addCriterion("F_t1_debit_card_max_fee in", values, "t1DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardMaxFeeNotIn(List<Long> values) {
            addCriterion("F_t1_debit_card_max_fee not in", values, "t1DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardMaxFeeBetween(Long value1, Long value2) {
            addCriterion("F_t1_debit_card_max_fee between", value1, value2, "t1DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT1DebitCardMaxFeeNotBetween(Long value1, Long value2) {
            addCriterion("F_t1_debit_card_max_fee not between", value1, value2, "t1DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT1CreditCardCommissionIsNull() {
            addCriterion("F_t1_credit_card_commission is null");
            return (Criteria) this;
        }

        public Criteria andT1CreditCardCommissionIsNotNull() {
            addCriterion("F_t1_credit_card_commission is not null");
            return (Criteria) this;
        }

        public Criteria andT1CreditCardCommissionEqualTo(Long value) {
            addCriterion("F_t1_credit_card_commission =", value, "t1CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1CreditCardCommissionNotEqualTo(Long value) {
            addCriterion("F_t1_credit_card_commission <>", value, "t1CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1CreditCardCommissionGreaterThan(Long value) {
            addCriterion("F_t1_credit_card_commission >", value, "t1CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1CreditCardCommissionGreaterThanOrEqualTo(Long value) {
            addCriterion("F_t1_credit_card_commission >=", value, "t1CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1CreditCardCommissionLessThan(Long value) {
            addCriterion("F_t1_credit_card_commission <", value, "t1CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1CreditCardCommissionLessThanOrEqualTo(Long value) {
            addCriterion("F_t1_credit_card_commission <=", value, "t1CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1CreditCardCommissionIn(List<Long> values) {
            addCriterion("F_t1_credit_card_commission in", values, "t1CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1CreditCardCommissionNotIn(List<Long> values) {
            addCriterion("F_t1_credit_card_commission not in", values, "t1CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1CreditCardCommissionBetween(Long value1, Long value2) {
            addCriterion("F_t1_credit_card_commission between", value1, value2, "t1CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1CreditCardCommissionNotBetween(Long value1, Long value2) {
            addCriterion("F_t1_credit_card_commission not between", value1, value2, "t1CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1OverseasCardCommissionIsNull() {
            addCriterion("F_t1_overseas_card_commission is null");
            return (Criteria) this;
        }

        public Criteria andT1OverseasCardCommissionIsNotNull() {
            addCriterion("F_t1_overseas_card_commission is not null");
            return (Criteria) this;
        }

        public Criteria andT1OverseasCardCommissionEqualTo(Long value) {
            addCriterion("F_t1_overseas_card_commission =", value, "t1OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1OverseasCardCommissionNotEqualTo(Long value) {
            addCriterion("F_t1_overseas_card_commission <>", value, "t1OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1OverseasCardCommissionGreaterThan(Long value) {
            addCriterion("F_t1_overseas_card_commission >", value, "t1OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1OverseasCardCommissionGreaterThanOrEqualTo(Long value) {
            addCriterion("F_t1_overseas_card_commission >=", value, "t1OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1OverseasCardCommissionLessThan(Long value) {
            addCriterion("F_t1_overseas_card_commission <", value, "t1OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1OverseasCardCommissionLessThanOrEqualTo(Long value) {
            addCriterion("F_t1_overseas_card_commission <=", value, "t1OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1OverseasCardCommissionIn(List<Long> values) {
            addCriterion("F_t1_overseas_card_commission in", values, "t1OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1OverseasCardCommissionNotIn(List<Long> values) {
            addCriterion("F_t1_overseas_card_commission not in", values, "t1OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1OverseasCardCommissionBetween(Long value1, Long value2) {
            addCriterion("F_t1_overseas_card_commission between", value1, value2, "t1OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT1OverseasCardCommissionNotBetween(Long value1, Long value2) {
            addCriterion("F_t1_overseas_card_commission not between", value1, value2, "t1OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardCommissionIsNull() {
            addCriterion("F_t0_debit_card_commission is null");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardCommissionIsNotNull() {
            addCriterion("F_t0_debit_card_commission is not null");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardCommissionEqualTo(Long value) {
            addCriterion("F_t0_debit_card_commission =", value, "t0DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardCommissionNotEqualTo(Long value) {
            addCriterion("F_t0_debit_card_commission <>", value, "t0DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardCommissionGreaterThan(Long value) {
            addCriterion("F_t0_debit_card_commission >", value, "t0DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardCommissionGreaterThanOrEqualTo(Long value) {
            addCriterion("F_t0_debit_card_commission >=", value, "t0DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardCommissionLessThan(Long value) {
            addCriterion("F_t0_debit_card_commission <", value, "t0DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardCommissionLessThanOrEqualTo(Long value) {
            addCriterion("F_t0_debit_card_commission <=", value, "t0DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardCommissionIn(List<Long> values) {
            addCriterion("F_t0_debit_card_commission in", values, "t0DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardCommissionNotIn(List<Long> values) {
            addCriterion("F_t0_debit_card_commission not in", values, "t0DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardCommissionBetween(Long value1, Long value2) {
            addCriterion("F_t0_debit_card_commission between", value1, value2, "t0DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardCommissionNotBetween(Long value1, Long value2) {
            addCriterion("F_t0_debit_card_commission not between", value1, value2, "t0DebitCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardMaxFeeIsNull() {
            addCriterion("F_t0_debit_card_max_fee is null");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardMaxFeeIsNotNull() {
            addCriterion("F_t0_debit_card_max_fee is not null");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardMaxFeeEqualTo(Long value) {
            addCriterion("F_t0_debit_card_max_fee =", value, "t0DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardMaxFeeNotEqualTo(Long value) {
            addCriterion("F_t0_debit_card_max_fee <>", value, "t0DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardMaxFeeGreaterThan(Long value) {
            addCriterion("F_t0_debit_card_max_fee >", value, "t0DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardMaxFeeGreaterThanOrEqualTo(Long value) {
            addCriterion("F_t0_debit_card_max_fee >=", value, "t0DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardMaxFeeLessThan(Long value) {
            addCriterion("F_t0_debit_card_max_fee <", value, "t0DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardMaxFeeLessThanOrEqualTo(Long value) {
            addCriterion("F_t0_debit_card_max_fee <=", value, "t0DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardMaxFeeIn(List<Long> values) {
            addCriterion("F_t0_debit_card_max_fee in", values, "t0DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardMaxFeeNotIn(List<Long> values) {
            addCriterion("F_t0_debit_card_max_fee not in", values, "t0DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardMaxFeeBetween(Long value1, Long value2) {
            addCriterion("F_t0_debit_card_max_fee between", value1, value2, "t0DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT0DebitCardMaxFeeNotBetween(Long value1, Long value2) {
            addCriterion("F_t0_debit_card_max_fee not between", value1, value2, "t0DebitCardMaxFee");
            return (Criteria) this;
        }

        public Criteria andT0CreditCardCommissionIsNull() {
            addCriterion("F_t0_credit_card_commission is null");
            return (Criteria) this;
        }

        public Criteria andT0CreditCardCommissionIsNotNull() {
            addCriterion("F_t0_credit_card_commission is not null");
            return (Criteria) this;
        }

        public Criteria andT0CreditCardCommissionEqualTo(Long value) {
            addCriterion("F_t0_credit_card_commission =", value, "t0CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0CreditCardCommissionNotEqualTo(Long value) {
            addCriterion("F_t0_credit_card_commission <>", value, "t0CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0CreditCardCommissionGreaterThan(Long value) {
            addCriterion("F_t0_credit_card_commission >", value, "t0CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0CreditCardCommissionGreaterThanOrEqualTo(Long value) {
            addCriterion("F_t0_credit_card_commission >=", value, "t0CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0CreditCardCommissionLessThan(Long value) {
            addCriterion("F_t0_credit_card_commission <", value, "t0CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0CreditCardCommissionLessThanOrEqualTo(Long value) {
            addCriterion("F_t0_credit_card_commission <=", value, "t0CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0CreditCardCommissionIn(List<Long> values) {
            addCriterion("F_t0_credit_card_commission in", values, "t0CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0CreditCardCommissionNotIn(List<Long> values) {
            addCriterion("F_t0_credit_card_commission not in", values, "t0CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0CreditCardCommissionBetween(Long value1, Long value2) {
            addCriterion("F_t0_credit_card_commission between", value1, value2, "t0CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0CreditCardCommissionNotBetween(Long value1, Long value2) {
            addCriterion("F_t0_credit_card_commission not between", value1, value2, "t0CreditCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0OverseasCardCommissionIsNull() {
            addCriterion("F_t0_overseas_card_commission is null");
            return (Criteria) this;
        }

        public Criteria andT0OverseasCardCommissionIsNotNull() {
            addCriterion("F_t0_overseas_card_commission is not null");
            return (Criteria) this;
        }

        public Criteria andT0OverseasCardCommissionEqualTo(Long value) {
            addCriterion("F_t0_overseas_card_commission =", value, "t0OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0OverseasCardCommissionNotEqualTo(Long value) {
            addCriterion("F_t0_overseas_card_commission <>", value, "t0OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0OverseasCardCommissionGreaterThan(Long value) {
            addCriterion("F_t0_overseas_card_commission >", value, "t0OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0OverseasCardCommissionGreaterThanOrEqualTo(Long value) {
            addCriterion("F_t0_overseas_card_commission >=", value, "t0OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0OverseasCardCommissionLessThan(Long value) {
            addCriterion("F_t0_overseas_card_commission <", value, "t0OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0OverseasCardCommissionLessThanOrEqualTo(Long value) {
            addCriterion("F_t0_overseas_card_commission <=", value, "t0OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0OverseasCardCommissionIn(List<Long> values) {
            addCriterion("F_t0_overseas_card_commission in", values, "t0OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0OverseasCardCommissionNotIn(List<Long> values) {
            addCriterion("F_t0_overseas_card_commission not in", values, "t0OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0OverseasCardCommissionBetween(Long value1, Long value2) {
            addCriterion("F_t0_overseas_card_commission between", value1, value2, "t0OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0OverseasCardCommissionNotBetween(Long value1, Long value2) {
            addCriterion("F_t0_overseas_card_commission not between", value1, value2, "t0OverseasCardCommission");
            return (Criteria) this;
        }

        public Criteria andT0CommissionFixedIsNull() {
            addCriterion("F_t0_commission_fixed is null");
            return (Criteria) this;
        }

        public Criteria andT0CommissionFixedIsNotNull() {
            addCriterion("F_t0_commission_fixed is not null");
            return (Criteria) this;
        }

        public Criteria andT0CommissionFixedEqualTo(Long value) {
            addCriterion("F_t0_commission_fixed =", value, "t0CommissionFixed");
            return (Criteria) this;
        }

        public Criteria andT0CommissionFixedNotEqualTo(Long value) {
            addCriterion("F_t0_commission_fixed <>", value, "t0CommissionFixed");
            return (Criteria) this;
        }

        public Criteria andT0CommissionFixedGreaterThan(Long value) {
            addCriterion("F_t0_commission_fixed >", value, "t0CommissionFixed");
            return (Criteria) this;
        }

        public Criteria andT0CommissionFixedGreaterThanOrEqualTo(Long value) {
            addCriterion("F_t0_commission_fixed >=", value, "t0CommissionFixed");
            return (Criteria) this;
        }

        public Criteria andT0CommissionFixedLessThan(Long value) {
            addCriterion("F_t0_commission_fixed <", value, "t0CommissionFixed");
            return (Criteria) this;
        }

        public Criteria andT0CommissionFixedLessThanOrEqualTo(Long value) {
            addCriterion("F_t0_commission_fixed <=", value, "t0CommissionFixed");
            return (Criteria) this;
        }

        public Criteria andT0CommissionFixedIn(List<Long> values) {
            addCriterion("F_t0_commission_fixed in", values, "t0CommissionFixed");
            return (Criteria) this;
        }

        public Criteria andT0CommissionFixedNotIn(List<Long> values) {
            addCriterion("F_t0_commission_fixed not in", values, "t0CommissionFixed");
            return (Criteria) this;
        }

        public Criteria andT0CommissionFixedBetween(Long value1, Long value2) {
            addCriterion("F_t0_commission_fixed between", value1, value2, "t0CommissionFixed");
            return (Criteria) this;
        }

        public Criteria andT0CommissionFixedNotBetween(Long value1, Long value2) {
            addCriterion("F_t0_commission_fixed not between", value1, value2, "t0CommissionFixed");
            return (Criteria) this;
        }

        public Criteria andMerchantSourceIsNull() {
            addCriterion("F_merchant_source is null");
            return (Criteria) this;
        }

        public Criteria andMerchantSourceIsNotNull() {
            addCriterion("F_merchant_source is not null");
            return (Criteria) this;
        }

        public Criteria andMerchantSourceEqualTo(Integer value) {
            addCriterion("F_merchant_source =", value, "merchantSource");
            return (Criteria) this;
        }

        public Criteria andMerchantSourceNotEqualTo(Integer value) {
            addCriterion("F_merchant_source <>", value, "merchantSource");
            return (Criteria) this;
        }

        public Criteria andMerchantSourceGreaterThan(Integer value) {
            addCriterion("F_merchant_source >", value, "merchantSource");
            return (Criteria) this;
        }

        public Criteria andMerchantSourceGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_merchant_source >=", value, "merchantSource");
            return (Criteria) this;
        }

        public Criteria andMerchantSourceLessThan(Integer value) {
            addCriterion("F_merchant_source <", value, "merchantSource");
            return (Criteria) this;
        }

        public Criteria andMerchantSourceLessThanOrEqualTo(Integer value) {
            addCriterion("F_merchant_source <=", value, "merchantSource");
            return (Criteria) this;
        }

        public Criteria andMerchantSourceIn(List<Integer> values) {
            addCriterion("F_merchant_source in", values, "merchantSource");
            return (Criteria) this;
        }

        public Criteria andMerchantSourceNotIn(List<Integer> values) {
            addCriterion("F_merchant_source not in", values, "merchantSource");
            return (Criteria) this;
        }

        public Criteria andMerchantSourceBetween(Integer value1, Integer value2) {
            addCriterion("F_merchant_source between", value1, value2, "merchantSource");
            return (Criteria) this;
        }

        public Criteria andMerchantSourceNotBetween(Integer value1, Integer value2) {
            addCriterion("F_merchant_source not between", value1, value2, "merchantSource");
            return (Criteria) this;
        }

        public Criteria andT0commissionByWeixinActivityIsNull() {
            addCriterion("F_t0commission_by_weixin_activity is null");
            return (Criteria) this;
        }

        public Criteria andT0commissionByWeixinActivityIsNotNull() {
            addCriterion("F_t0commission_by_weixin_activity is not null");
            return (Criteria) this;
        }

        public Criteria andT0commissionByWeixinActivityEqualTo(Integer value) {
            addCriterion("F_t0commission_by_weixin_activity =", value, "t0commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT0commissionByWeixinActivityNotEqualTo(Integer value) {
            addCriterion("F_t0commission_by_weixin_activity <>", value, "t0commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT0commissionByWeixinActivityGreaterThan(Integer value) {
            addCriterion("F_t0commission_by_weixin_activity >", value, "t0commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT0commissionByWeixinActivityGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_t0commission_by_weixin_activity >=", value, "t0commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT0commissionByWeixinActivityLessThan(Integer value) {
            addCriterion("F_t0commission_by_weixin_activity <", value, "t0commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT0commissionByWeixinActivityLessThanOrEqualTo(Integer value) {
            addCriterion("F_t0commission_by_weixin_activity <=", value, "t0commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT0commissionByWeixinActivityIn(List<Integer> values) {
            addCriterion("F_t0commission_by_weixin_activity in", values, "t0commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT0commissionByWeixinActivityNotIn(List<Integer> values) {
            addCriterion("F_t0commission_by_weixin_activity not in", values, "t0commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT0commissionByWeixinActivityBetween(Integer value1, Integer value2) {
            addCriterion("F_t0commission_by_weixin_activity between", value1, value2, "t0commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT0commissionByWeixinActivityNotBetween(Integer value1, Integer value2) {
            addCriterion("F_t0commission_by_weixin_activity not between", value1, value2, "t0commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT1commissionByWeixinActivityIsNull() {
            addCriterion("F_t1commission_by_weixin_activity is null");
            return (Criteria) this;
        }

        public Criteria andT1commissionByWeixinActivityIsNotNull() {
            addCriterion("F_t1commission_by_weixin_activity is not null");
            return (Criteria) this;
        }

        public Criteria andT1commissionByWeixinActivityEqualTo(Integer value) {
            addCriterion("F_t1commission_by_weixin_activity =", value, "t1commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT1commissionByWeixinActivityNotEqualTo(Integer value) {
            addCriterion("F_t1commission_by_weixin_activity <>", value, "t1commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT1commissionByWeixinActivityGreaterThan(Integer value) {
            addCriterion("F_t1commission_by_weixin_activity >", value, "t1commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT1commissionByWeixinActivityGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_t1commission_by_weixin_activity >=", value, "t1commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT1commissionByWeixinActivityLessThan(Integer value) {
            addCriterion("F_t1commission_by_weixin_activity <", value, "t1commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT1commissionByWeixinActivityLessThanOrEqualTo(Integer value) {
            addCriterion("F_t1commission_by_weixin_activity <=", value, "t1commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT1commissionByWeixinActivityIn(List<Integer> values) {
            addCriterion("F_t1commission_by_weixin_activity in", values, "t1commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT1commissionByWeixinActivityNotIn(List<Integer> values) {
            addCriterion("F_t1commission_by_weixin_activity not in", values, "t1commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT1commissionByWeixinActivityBetween(Integer value1, Integer value2) {
            addCriterion("F_t1commission_by_weixin_activity between", value1, value2, "t1commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andT1commissionByWeixinActivityNotBetween(Integer value1, Integer value2) {
            addCriterion("F_t1commission_by_weixin_activity not between", value1, value2, "t1commissionByWeixinActivity");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncIsNull() {
            addCriterion("F_bankcard_phone_enc is null");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncIsNotNull() {
            addCriterion("F_bankcard_phone_enc is not null");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncEqualTo(String value) {
            addCriterion("F_bankcard_phone_enc =", value, "bankcardPhoneEnc");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncNotEqualTo(String value) {
            addCriterion("F_bankcard_phone_enc <>", value, "bankcardPhoneEnc");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncGreaterThan(String value) {
            addCriterion("F_bankcard_phone_enc >", value, "bankcardPhoneEnc");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncGreaterThanOrEqualTo(String value) {
            addCriterion("F_bankcard_phone_enc >=", value, "bankcardPhoneEnc");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncLessThan(String value) {
            addCriterion("F_bankcard_phone_enc <", value, "bankcardPhoneEnc");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncLessThanOrEqualTo(String value) {
            addCriterion("F_bankcard_phone_enc <=", value, "bankcardPhoneEnc");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncLike(String value) {
            addCriterion("F_bankcard_phone_enc like", value, "bankcardPhoneEnc");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncNotLike(String value) {
            addCriterion("F_bankcard_phone_enc not like", value, "bankcardPhoneEnc");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncIn(List<String> values) {
            addCriterion("F_bankcard_phone_enc in", values, "bankcardPhoneEnc");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncNotIn(List<String> values) {
            addCriterion("F_bankcard_phone_enc not in", values, "bankcardPhoneEnc");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncBetween(String value1, String value2) {
            addCriterion("F_bankcard_phone_enc between", value1, value2, "bankcardPhoneEnc");
            return (Criteria) this;
        }

        public Criteria andBankcardPhoneEncNotBetween(String value1, String value2) {
            addCriterion("F_bankcard_phone_enc not between", value1, value2, "bankcardPhoneEnc");
            return (Criteria) this;
        }

        public Criteria andCompanyChildTypeIsNull() {
            addCriterion("F_company_child_type is null");
            return (Criteria) this;
        }

        public Criteria andCompanyChildTypeIsNotNull() {
            addCriterion("F_company_child_type is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyChildTypeEqualTo(Integer value) {
            addCriterion("F_company_child_type =", value, "companyChildType");
            return (Criteria) this;
        }

        public Criteria andCompanyChildTypeNotEqualTo(Integer value) {
            addCriterion("F_company_child_type <>", value, "companyChildType");
            return (Criteria) this;
        }

        public Criteria andCompanyChildTypeGreaterThan(Integer value) {
            addCriterion("F_company_child_type >", value, "companyChildType");
            return (Criteria) this;
        }

        public Criteria andCompanyChildTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_company_child_type >=", value, "companyChildType");
            return (Criteria) this;
        }

        public Criteria andCompanyChildTypeLessThan(Integer value) {
            addCriterion("F_company_child_type <", value, "companyChildType");
            return (Criteria) this;
        }

        public Criteria andCompanyChildTypeLessThanOrEqualTo(Integer value) {
            addCriterion("F_company_child_type <=", value, "companyChildType");
            return (Criteria) this;
        }

        public Criteria andCompanyChildTypeIn(List<Integer> values) {
            addCriterion("F_company_child_type in", values, "companyChildType");
            return (Criteria) this;
        }

        public Criteria andCompanyChildTypeNotIn(List<Integer> values) {
            addCriterion("F_company_child_type not in", values, "companyChildType");
            return (Criteria) this;
        }

        public Criteria andCompanyChildTypeBetween(Integer value1, Integer value2) {
            addCriterion("F_company_child_type between", value1, value2, "companyChildType");
            return (Criteria) this;
        }

        public Criteria andCompanyChildTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("F_company_child_type not between", value1, value2, "companyChildType");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameIsNull() {
            addCriterion("F_contractor_license_name is null");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameIsNotNull() {
            addCriterion("F_contractor_license_name is not null");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameEqualTo(String value) {
            addCriterion("F_contractor_license_name =", value, "contractorLicenseName");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameNotEqualTo(String value) {
            addCriterion("F_contractor_license_name <>", value, "contractorLicenseName");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameGreaterThan(String value) {
            addCriterion("F_contractor_license_name >", value, "contractorLicenseName");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameGreaterThanOrEqualTo(String value) {
            addCriterion("F_contractor_license_name >=", value, "contractorLicenseName");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameLessThan(String value) {
            addCriterion("F_contractor_license_name <", value, "contractorLicenseName");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameLessThanOrEqualTo(String value) {
            addCriterion("F_contractor_license_name <=", value, "contractorLicenseName");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameLike(String value) {
            addCriterion("F_contractor_license_name like", value, "contractorLicenseName");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameNotLike(String value) {
            addCriterion("F_contractor_license_name not like", value, "contractorLicenseName");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameIn(List<String> values) {
            addCriterion("F_contractor_license_name in", values, "contractorLicenseName");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameNotIn(List<String> values) {
            addCriterion("F_contractor_license_name not in", values, "contractorLicenseName");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameBetween(String value1, String value2) {
            addCriterion("F_contractor_license_name between", value1, value2, "contractorLicenseName");
            return (Criteria) this;
        }

        public Criteria andContractorLicenseNameNotBetween(String value1, String value2) {
            addCriterion("F_contractor_license_name not between", value1, value2, "contractorLicenseName");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}